| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Zip Codes
I have a list of names and addresses in Excel. Some of the zip codes are in
just the regular 5 digit zip code format and some are in the zip + 4 format. I would like to eliminate the additional 4 digits off the zip codes that have them without having to manually delete those numbers from each cell. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
| Printing zip codes that start with 0 | Excel Discussion (Misc queries) | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
| Set column to only allow certain codes??? | Excel Worksheet Functions | |||
| I am not able to format cells for zip codes | Excel Worksheet Functions | |||
Threaded Mode
