L
laudrup
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
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