| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel sort ( exclude letters include hyphens)?
I'm trying to use the sort comand on excel so that my list looks like this 05-024 AB05-543 05-678 002-23 What was asked of me is to sort the list so that letters are not taken into consideration and so that it is sorted by the number of digits to the left of the hyphen then by value. Does anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Include/Exclude Holiday from Automatic Sheet Creation | Excel Discussion (Misc queries) | |||
| Include ability to sort Excel cells by colour | Excel Worksheet Functions | |||
| Use networkdays INCLUDE weekends, Exclude holidays | Excel Worksheet Functions | |||
| Can auto number (or OFFSET) include letters? | Excel Worksheet Functions | |||
| Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) | |||
Threaded Mode
