| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting characters, ignoring numbers
I have a list with a column of street addresses. I would like to sort by
street but ignore the house number. for example is want the results to be: 123 Pine 456 Pine 145 Ross 668 Ross NOT: 123 Pine 145 Ross 456 Pine 668 Ross Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data bust ignoring numbers | Excel Discussion (Misc queries) | |||
| Ignoring punctuation when sorting | Excel Discussion (Misc queries) | |||
| Ignoring #N/A in sorting? | Excel Discussion (Misc queries) | |||
| Ignoring characters when sorting | Excel Discussion (Misc queries) | |||
| Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
Threaded Mode
