| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Street Numbers
I'm using Excel 2007. How would I sort the following:
1111th 131st 1st 223rd 2nd 3rd 65th to get: 1st 2nd 3rd 65th 131st 223rd 1111th |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate address numbers from street name | Excel Worksheet Functions | |||
| How do you remove the numbers from a street address in EXCELL? | Excel Worksheet Functions | |||
| Sorting street addresses | Excel Discussion (Misc queries) | |||
| how do I convert cell 'Street,#' to '# Street' these are addresse | Excel Worksheet Functions | |||
| How do I sort a column of street number/street name by the stree. | Excel Worksheet Functions | |||
Threaded Mode
