Multi-line addresses in one Excel cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to export some contacts to Excel, the parts of the longer
addresses come out in one cell separated by little boxes instead of having
each part in BusinessStreet, BusinessStreet1 etc. This happens even though in
Outlook each part is on a separate line.

Sometimes the reverse happens when importing from Excel - the different
BusinessStreets come in without a proper line break.

How can I fix this?

Cheryl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Contacts 1
Exporting street addresses correctly? 5
How to input values to BusinessStreet2 and BusinessStreet3 1
Parsing line breaks into separate cells 3
BusinessStreet 2 2
Postal Address Format 2
how do i import excel address files to outlook 1
Problem importing data from Excel into Outlook 2007 Contacts 3

Back
Top