Business Addresses Imported from Outlook

C

cardan

Hi All,

I am having a problem that I cannot seem to find in previous
discussions regarding Outlook. I have imported all the fields from
Outlook to Excel. It works fine except for the business addresses. The
street address is on one line, the city, state, zip is on a line
directly below it and the country is below that - all in one cell. for
example cell content looks like this

123 Main St
New York, NY 11121
United State of America

Essentially it seems to be a "carriage return" within the cell, but
there are no special characters at the end of each line.

I would like to find a way to pull these three lines into separate
cells in the same row. Any help would be greatly appreciated! Thank
you for your time.
 
J

John

Hi Cardan
One way, If you don't have too many entries, you can use > Data>Text to
Columns>
HTH
John
 
C

cardan

Hi Cardan
One way, If you don't have too many entries, you can use > Data>Text to
Columns>
HTH

Hi John,

I tried that already. Fixed Width does not work due to varying lengths
of the text and Delimited only picks up the top line. It does pick up
the bottom 2 lines so I can't separate them out. Do I have to write
code for this?
 
J

John

Hi Cardan
I'm not sure what you mean by Fixed Width won't work due to varying lengths
of text.
You know you can change the Break Line, move them, delete them and if the
text is long you just scroll with the scrollbar.
Yes VBA codes would do the trick, but that's beyond me, You'll need help
from those expert.
Regards
John
Hi Cardan
One way, If you don't have too many entries, you can use > Data>Text to
Columns>
HTH

Hi John,

I tried that already. Fixed Width does not work due to varying lengths
of the text and Delimited only picks up the top line. It does pick up
the bottom 2 lines so I can't separate them out. Do I have to write
code for this?
 
J

John

Hi Cardan
Ignore my first comment, was not thinking about large volume of text.
Hopefully a macro (VBA) will help you.
Regards
John
 

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

Top