Help with sorting numbers with text suffix

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top