Hi,

I have some comma delimited data that I have got in excel. There are 74
cells and in each cell there are several hundred comma delimited
numbers. I have tried to use the "Text to columns" option (under the
data menu) to get the comma delimited numbers into cells but if I do
this I lose the last bit of the data as there are more comma delimited
items in each cell than there are columns in the worksheet (only 256
columns in worksheet). What I need is a "Text to rows" option but I
can't find this.

Does anyone have any suggestions?

Cheers,
Laudrup


--
laudrup
------------------------------------------------------------------------
laudrup's Profile: http://www.excelforum.com/member.php...o&userid=32245
View this thread: http://www.excelforum.com/showthread...hreadid=548235