Could you paste the content of one cell so I can see the data and determine the best method to use
So you want the value
"company xxx, Inc."
to be changes to
"company xxx Inc."
I also need to know which column are these addresses in, and they start from which row
I also need to know which column are these addresses in, and they start from which row so I can send you the formula
Or would you prefer to send me your file so I can set the formula up on it directly
Ok try this and if you still need help you can send me the file so I can fix it for you
Select columns C thru P
Press the COMMAND + F keys to bring up the Find & Replace dialog box
Click the Replace tab
Type a comma in the 'Find what' field
Type a space in the 'Replace with' field
Press the 'Replace All'
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution