Hi,
highlight the cell , data, text to columns, here you have 2 options if you
use Delimited, in the 2nd screen will ask you for the character to identify
in order to split the cell in columns, if you use Fixed with, you will have
to click where you want the column to be


"mark_jm via OfficeKB.com" wrote:

I have exported some stuff from an outlook inbox into excel for analysis.
The boby of the emails I have exported contain data which I need, each piece
of data is on a seperate row in the email boby.

"CDControls.iAD
AnaBACK PRSR MBAR HIGH
WARNING !!
Reg No: TA656
Serial No: 666069
BATT: 26.9 volts
GSM Sig: 20 db
MEM:5481/86400
"
When I export it it comes in to excel all in one cell with a character
seperating each row that I cant reproduce. Its 2 very bold letter "l"'s which
seems to the the character that forces the new row i the email. How can I
identify the character to properly seperate each row above into seperate
columns in the spreadsheet?

All help appreciated

Thanks

Mark

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201004/1

.