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