deleting a comma from every cell in a column
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?
|