| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting by 5 digit & 5 digit plus 4 zip codes
I need to sort a mailing list by zip code that contains mixed 5 digit and 5
digit plus 4 zip codes. How do I get the plus 4 zip codes in order behind the 5 digit zip codes? All of the plus 4 zip codes appear in zip code order at the end of all of the 5 digit zip codes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a six digit number by terminal digit | Excel Worksheet Functions | |||
| Need to convert list of 5 digit zip codes to ranges where possible | Excel Worksheet Functions | |||
| sorting alpha numeric list by first left digit | New Users to Excel | |||
| 12 digit code sorting | Excel Worksheet Functions | |||
| only 5 digit zip codes | Excel Discussion (Misc queries) | |||
Threaded Mode
