View Single Post
  #1   Report Post  
Old February 25th 08, 11:09 PM 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

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.