Select your data
EditReplace, Find what is a comma and Replace with nothing
Press Replace all

--
Kind regards,

Niek Otten

"Annette" wrote in message
...
I have a long column and I need to take out the commar between the State
and
the zip code - anyone know how to do this without going into each cell??