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
|