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?

find and replace , with nothing

sbaum wrote:

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?

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

"sbaum" wrote in message
...
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?