| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
remove punctuation from address
I need help removing commas, periods, parenthesis, dashes, etc from an
address file a customer supplied to me. Below is one row for example. In order to dump the address file into our system, I need to remove the punctuation. Is there a formula that will do this for me? The Name, Company and address are each in a different cell. Ed Olsen, Sr Seattle Mill & Industrial Supply 3223-A 164th St. SW -- Thanks, Mary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
| Separate address column to Five columns | Excel Worksheet Functions | |||
| Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
| Address from one worksheet to another | Excel Worksheet Functions | |||
| How do I remove all text to the left of the @ in an email address | Excel Worksheet Functions | |||
Threaded Mode
