ExcelBanter - Alphanumeric Sort 1, 1a

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Alphanumeric Sort 1, 1a (https://www.excelbanter.com/excel-discussion-misc-queries/118731-alphanumeric-sort-1-1a.html)

Kim

Alphanumeric Sort 1, 1a

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

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

Kim

Alphanumeric Sort 1, 1a

thank you

"Scott" wrote:

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

All times are GMT +1. The time now is 02:41 AM.