Alphanumeric Sort 1, 1a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
thank you

Scott said:
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
Click to expand...
 
Back
Top