Hi Bob,
You can select the columns and use CTRL+H
to remove commas, or replace them with spaces.
But why would you want to make the worksheet hard to read,
put the items in separate cells with data, text to columns.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Bob Levin" wrote in message
...
after exporting contacts
to the excel worksheet, why is it that in the address field, there are
marks
separating the street from the city, the city from the state, and the
state
from the zip code? It's almost like a "comma separated file. in field
mapping
I had the option to export the street, city, state, and zip in separate
fields. I prefer them to be in the same field but can those marks be
removed
somehow? Thanks again

--
Bob Levin