| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data bust ignoring numbers
I have a list of addresses, where I want to sort by road column, but ignore
the numbers in front of the road name. When I try to sort it sorts by the house number. e.g 1 Smith Road 3 John Road 4 Yellow Road |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring punctuation when sorting | Excel Discussion (Misc queries) | |||
| Sorting by month and year and ignoring the day | Excel Discussion (Misc queries) | |||
| excel bust | Excel Discussion (Misc queries) | |||
| Ignoring #N/A in sorting? | Excel Discussion (Misc queries) | |||
| Ignoring characters when sorting | Excel Discussion (Misc queries) | |||
Threaded Mode
