| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting numeric and alpha entries
I have a list that contains a field for road number. It sorts like the left
column, but I want it to look like the right column: Road Number Road Number 2 1A 11 11 21 100 100 101 101 1000 200 10000 201 10000A 1000 2 10000 2A 10000A 2B 1A 200 2A 201 2B etc I have formatted the data to be text, but that doesn't deliver the sort order that I want. I am hoping that I can use formulas to do this, as I am not familiar with VBA. Thanks in advance for your help. -- Thanks, Allison |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Alpha-Numeric Values | Charts and Charting in Excel | |||
| Sorting Cells With Alpha Numeric Values | Charts and Charting in Excel | |||
| Sorting Alpha Numeric Part 2 | Excel Discussion (Misc queries) | |||
| Sorting Alpha Numeric | Excel Discussion (Misc queries) | |||
| Alpha-Numeric Sorting | Excel Discussion (Misc queries) | |||
Threaded Mode
