deleting a comma from every cell in a column

[sbaum]

I have copied from the web a list of names, address, city, state and zip.
The problem is in the column with the street address there is a comma at the
end of each cell.

Is there a way to delete the comma from every cell in that columm?

 

[Bob I]

find and replace , with nothing

 

[Peo Sjoblom]

If that is the only comma in each cell of that column press ctrl + H and
replace , with nothing (leave replace with box)empty.


If there are multiple commas and the comma you want to replace is the last
visible character in the cells use a help column and


=IF(RIGHT(TRIM(A1))=",",LEFT(TRIM(A1),LEN(TRIM(A1))-1),A1)


then copy down and copy and paste special over the old values and finally
delete the help column

--


Regards,


Peo Sjoblom