| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing the +4 from zip+4
Column contains 10 characters (e.g. 02453-1234) making up the zip+4. I need
to remove the last 5 characters, leaving only the basic 5 digit zip-code. The column contains about 10,000 entries. Please suggest methods by which this can be done. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing duplicate records in excel, how to do it? | Excel Discussion (Misc queries) | |||
| Removing ' character from cells | Excel Discussion (Misc queries) | |||
| Removing a drop down list from a cell | Excel Discussion (Misc queries) | |||
| Removing Hidden But Keep Values | Excel Discussion (Misc queries) | |||
| Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
