Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2007

Tip: Looking for answers? Try searching our database.

convert soft line breaks to new cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
band@jiveaces.com - 24 Jan 2007 16:18 GMT
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
Gord Dibben - 24 Jan 2007 17:41 GMT
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

>I need heeeeeeelp!!!!
>
[quoted text clipped - 15 lines]
>Any info would be mucho appreciated!
>Alex

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.