| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What function should I use to convert 43232- to 43232
On the zip codes on the column Zip are in the structure of:
nnnnn- (for example, "07444-") . What would be the function to get rid of all these "-"? On a differnt spreadsheet I have the zips as nnnnn-mmmm. I want to keep the nnnnn only. What function should I use? galsaba |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| Convert to Lower case (not with a function) | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Function to convert feet and inchs into decimal equivalents | Excel Worksheet Functions | |||
| How do I use Excel's convert function for apothecary weight? | Excel Worksheet Functions | |||
Threaded Mode
