View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default deleting a comma from every cell in a column

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?