View Single Post
  #4   Report Post  
Old February 26th 08, 03:14 AM posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default Sorting Numbers with letter suffixes

well, the caveat was:
.. presuming data as posted is representative

Since you have now extended the scope,
hang around awhile for better solutions from others
"Terry Bennett" wrote in message
Thanks Max.

I see your logic but this sorts all digits begining with a '1' first ...
hence 112 comes before 2. In the case of 2, 2A, etc it seems to sort
these randomly within the digits begining with 2s.