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