View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default CREATE CUSTOM SORT IN EXCEL

You could extract those final two digits into a helper column with
this:

=RIGHT(A1,2)

assuming your data is in A1, and copy this down.

Include the helper column within your sort range and sort on that as
the first field and your data as the second field.

Hope this helps.

Pete

On Nov 13, 2:49*pm, Grayhair
wrote:
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.