Deleting a Comma ","

[Maracay]

Hi guys,

Hi have a column with City, Address, Postal Code I need to delete the I
need to delete the “,†between Address and Postal code, the problem is that
is not located in a specific position, some postal codes are longer, some
times there is a space others double space, I want a way to search for that
second comma and deleted,

Thanks

 

[evoxfan]

You can hilight the column, ctrl+f, ".", then delete all. These will delete
all commas in your column though which you would have to either replace the
first comma or live without it.
Another option is that you could insert another two columns, then in the
first column enter a formula to find the second comma. In the next inserted
column enter a formula to replace the comma with a blank.The formulas would
look something like this:
Inserted column 1 (call it column B):=FIND(",",A1,10)
Inserted column 2 (call it column C):=REPLACE(A1,B1,1,"")
You can then copy your second column (I call it column C) and paste special
"values only" to replace Column A, then delete the inserted Column B & C.

Hope this helps you get started, Good Luck.

 

[Ron Rosenfeld]

Hi guys,

Hi have a column with City, Address, Postal Code I need to delete the I
need to delete the “,” between Address and Postal code, the problem is that
is not located in a specific position, some postal codes are longer, some
times there is a space others double space, I want a way to search for that
second comma and deleted,

Thanks

If your data is in A1:An

B1: =SUBSTITUTE(A1,",","",2)

Fill down as far as required.

You can then copy/paste-special *VALUES* over the original

--ron