Importing Outlook contacts to Access - Square for address break

[Steve Maiorano]

There are several contacts in my company's public folders
in Outlook that have two lines for the address instead of
one. When I export contacts from Outlook to Access for a
mailing list, that hard return appears in the address
column in Access as a square. I would like to get rid of
this square in Access or in Ecxel for a cleaner list, but
I can't find the symbol anywhere to search and replace it.
How can I get rid of this square? I am using Office 2003.
Thanks.

 

[Sue Mosher [MVP-Outlook]]

I believe it's a line feed -- Chr(10) -- or carriage return -- Chr(13).