Text to rows?

[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

 

[mrice]

This can be done by macro

Sub Test()
Open "C:\myCSVFile.csv" For Input As #1 'change as required
Do While Not EOF(1)
Line Input #1, FileLine
Counter = Counter + 1
X = Split(FileLine, ",")
For N = 0 To UBound(X)
Cells(N + 1, Counter) = X(N)
Next N
Loop
Close #1
End Su