View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Scott Scott is offline
external usenet poster
 
Posts: 87
Default Alphanumeric Sort 1, 1a

I'd convert the column to Text. (Data-Text to Columns...)

Then, sort, making sure to check "Sort number and numbers stored as
text separately."

Scott

Kim wrote:
Any suggestions on how to properly sort the following example? Thank you.
3
8
3a
3b
15
10
101
10a
10b
99
101b
Should be...
3
3a
3b
8
10
10a
10b
15
99
101
101a
101b