Help with sorting numbers with text suffix
 

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

Help with sorting numbers with text suffix
 

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

http://www.realezsites.com/bus/primi...e/products.php

Vaya con Dios,
Chuck, CABGx3


"Jackson" wrote in message
...
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

Help with sorting numbers with text suffix
 

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.

"Jackson" wrote:

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