Problem after exporting Outlook emails into Excel

[fuzzyjonclay]

Hi there everyone

I've just converted a bunch of emails from an Outlook folder into Excel. All went well except for the field that is the body of the email is causing me an issue.

In Excel, the converted field shows in the cell as e.g.:

Name John Smith Company John Smith Limited Position Managing Director

I would like to split this into its component parts and I tried to do this using the "Text to Columns" function.

However, when I actually look at the Excel cell, the various components of the line above are separated by a bunch of carriage returns, so they are not really on one line at all. This makes it impossible to use the "Text to Columns" function to split the cell up into the component parts.

So, I was wondering if there's a way to easily remove all carriage returns from a cell and thus make the contents appear all on one line?

I hope that makes sense!

Many thanks
Jon

 

[iliace]

Possibly use the SUBSTITUTE function, and then copy/paste values:

=SUBSTITUTE(A1, CHAR(13), "")

assuming that the carriage return is ASCII code 13.

 

[fuzzyjonclay]

Possibly use the SUBSTITUTE function, and then copy/paste values:

=SUBSTITUTE(A1, CHAR(13), "")

assuming that the carriage return is ASCII code 13.

Great, that works!

Thank you.
Jon