View Single Post
  #9   Report Post  
Old February 27th 08, 10:42 AM posted to microsoft.public.excel.worksheet.functions
Terry Bennett Terry Bennett is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 67
Default Sorting Numbers with letter suffixes

Thanks again guys for the suggestions - much appreciated.

Terry

"Terry Bennett" wrote in message
...
Is there a way I can sort numbers such that if I have a letter suffix (ie;
2A, 3B, etc), they are sorted after the original number, ie; 2A between 2
and 3 then 3B between 3 and 4?

Thanks.