Text to rows?

  • Thread starter Thread starter laudrup
  • Start date Start date
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
 
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
 
Back
Top