View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grayhair Grayhair is offline
external usenet poster
 
Posts: 1
Default CREATE CUSTOM SORT IN EXCEL

How do I sort the following text; EP2323A-01, EP2323A-02, EP2323A-03,
EP2323A-04, EP2323A-05, EP2323B-01, EP2323B-02, EP2323B-03,
EP2323B-04, EP2323B-05....EP2323F-05. when it is not in any particular
order? I want to sort by the number's 01 first then the letter A-F. Then the
number's 02 and then letters A-F.