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

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

Hi,

For more information, refer to the following topic in Microsoft Outlook 2003
online help. Clickkng on this topic will take you the following URL:
http://office.microsoft.com/en-us/ou...CL100626971033

Challa Prabhu


"Bob Levin" wrote:

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