Help with sorting numbers with text suffix

[Guest]

Need help sorting numeric. Currently sorts:
492947
494537S
49355
495234
5001H
690190
Need 5001H to be at the beginning, then 49355, then 492947 and so on.
Cell, format, column, set as "text" due to last character possibly being
alpha. Help please. Thanks.
Jackson

 

[CLR]

Take a look at Jim Cone's fine commercial add-in called "Special Sort".
It's available at

http://www.realezsites.com/bus/primitivesoftware/products.php

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Isn't there an a-z plus z-a sort in the data sort heading - believe when
working on an .xls file which was sorted in the alpha (a-z), the numbers came
first and then the alpha text - this depends on the column chosen as your
first (or main column) in the sort criteria box. Hope this helps.