| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ZIP CODES
I am working in a spreadsheet that has a column of zip codes in the zip + 4
format (00000-0000). All I need is the first 5 numbers of each zip. How do I convert it from the current format to just 5 digits, or can I split the data into 2 columns, one with the first 5 digits, and the other with the additional 4? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| only 5 digit zip codes | Excel Discussion (Misc queries) | |||
| VBA Codes | Excel Worksheet Functions | |||
| mail merge will not accept zip codes that start with a zero "label | Excel Discussion (Misc queries) | |||
| Cntrl find - cannot locate zip codes that start with zero. Possibl | Excel Discussion (Misc queries) | |||
| Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
Threaded Mode
