Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Custom Sort Error | Excel Discussion (Misc queries) | |||
Excel Charts - Create a custom data label | Charts and Charting in Excel | |||
How do I create a custom font color in Excel? | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
how do i create a custom calendar in excel? | Excel Discussion (Misc queries) |