| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing ZIP code formats in Excel 2003
I am trying to merge addresses into a mail program that won't accept 9-digit
ZIP codes - some of the addresses in my worksheet are the acceptable 5-digit ZIPs, some are the unaccepted 9-digit ZIPs. How do I efficiently trim or shorten the cells that now have 9-digits, without manually going to each cell and deleting the last 4 digits? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 autosave a changing file | Excel Discussion (Misc queries) | |||
| Opening Excel 2003 files in Excel 97 | Excel Discussion (Misc queries) | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| trying to open an excel file in excel 2003 | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
