Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to rows?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to rows?
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 Sub -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=548235 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
Totaling rows of text | Excel Worksheet Functions | |||
I want to chage a whole rows text color based on single cell valu. | Excel Worksheet Functions |