Alphanumeric Sort 1, 1a

[Kim]

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

 

[Scott]

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]

thank you

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