Export Contacts to excel.

[Guest]

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

 

[David McRitchie]

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.

 

[Guest]

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/outlook/HA010964221033.aspx?pid=CL100626971033

Challa Prabhu