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