you might be able to parse the text in the cell with a formula, provided
there's a regular identifier for each field in the cell, like "Name: ",
"E-mail: " etc. Then you could have your formula look for those identifying
words and pull out what comes after it. I'd have to see a sample of the data
in the cell in order to understand what the formula would have to look like.

"aquagas" wrote:


i have about 1000 emails in outlook that are automatic responces from
our website giving me peoples registration details
each bit of info is on a seperate line
when i export these emails out into an excel spreadsheet it puts all
the info into one column with 1000 rows with all the info in
when i try and do "text to columns" it wont seperate them out, as the
seperate bits of info are all on seperate lines within each row

there are about 4 lines in each of the 1000 rows and i want each line
to be a seperate column

any one got any ideas ?


--
aquagas
------------------------------------------------------------------------
aquagas's Profile: http://www.excelforum.com/member.php...o&userid=33365
View this thread: http://www.excelforum.com/showthread...hreadid=531939