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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
remove punctuation from address
Mary
you'll need to add a column and then input the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(A1,",",""),".",""),"-",""),"(",""),")","") Assuming your data starts in cell A1. Just drag down or AutoFill. Once you have the data, Copy and Paste Special | Values over the original. Import the cleaned up data into your system. Regards Trevor "Mary" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
remove punctuation from address
You may want to just do a series of edit|Replaces to remove whatever you
consider punctuation. Select the range edit|Replace what: , (comma) with: (leave blank or a space character????) replace all And just keep doing this for each of your characters to remove. Mary wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
remove punctuation from address
ASAP Utilities, a free add-in available from www.asap-utilities.com has a
feature that will let you selectively delete characters.......... Vaya con Dios, Chuck, CABGx3 "Mary" wrote: 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 |
Reply |
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 |