Business Addresses Imported from Outlook

[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.

 

[John]

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

 

[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?

 

[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?

 

[John]

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