convert soft line breaks to new cell

  • Thread starter Thread starter band
  • Start date Start date
B

band

I need heeeeeeelp!!!!

I need to export my outlook contacts into Excel in order to do a big
mail merge for a third party.

When i export my contacts folder, if I have more than one address line
in the "Address" part (e.g. top line has "Building Name", second line
has "number and Street Name") it puts both lines into the same cell in
excel with a line break.

This causes problems when I send it to someone else for printing onto
labels etc.

Is there a way in Outlook to force it to export each address line to a
new cell or a way in excel to convert the soft breaks within a cell to
a new cell?

Any info would be mucho appreciated!
Alex
 
The line break is usually the 0010 character.....maybe 0013

Try Data>Text to Columns>Delimited by>Other

Alt + 0010(using numpad)>Next and if looks OK>Finish.


Gord Dibben MS Excel MVP
 

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

cells with one to multiple lines 1
Excel Concatenate with line breaks but ignore blank cells 3
Merge cells with new line 7
Best Ways to Convert OST to PDF? 3
new line within a cell 2
Split cells with hard-coded line breaks 3
Exporting to CSV with embedded line breaks 1
Forcing Carriage Returns (or New Line)... 2

Back
Top