View Single Post
  #2   Report Post  
Old February 26th 08, 12:58 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

One way which might suffice, presuming data as posted is representative

Assuming data in A1 down
Put in B1, copy down:
=IF(A1="","",IF(ISNUMBER(A1),A1,LEFT(A1)+CODE(LEFT (A1))/10^10))
Then select both cols A & B, sort by col B, ascending
"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?