convert soft line breaks to new cell

Giganews Newsgroups
Subject: convert soft line breaks to new cell
Posted by:  ba…
Date: 24 Jan 2007

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!