Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-15-2012, 11:11 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to do an alpha numeric Sort By? Windows 7 64bit How to do an alpha numeric Sort By? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I think the easiest way is to use a helper column containing
Code:
=MID(A1,6,LEN(A1)-5)*1
( dragged down) which will give you a column containing the numbers then sort the range by that column. You can eventually hide this helper column
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
 

Tags
column, data, sort



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do an alpha numeric Sort By? Unique 3 char Alpha Numberic column mauricioaglr Excel 7 03-09-2012 06:45 PM
How to do an alpha numeric Sort By? alt+numeric doesn't work Kungen Word 3 12-02-2011 11:25 AM
How to do an alpha numeric Sort By? Word 2007 TOC Section Number w/Alpha Prefix? Gwen Butler Office 2 09-29-2011 06:10 AM
How to do an alpha numeric Sort By? Place pages in alpha order. Wskip49 Word 5 08-28-2011 07:54 PM
How to do an alpha numeric Sort By? [How To] Generate Alpha Numeric Values in Excel 2010 stnicholas81 Excel 1 07-25-2011 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft