Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to import a text file. I want the excel file to have 1/3 as many
rows as the text file; each row will have 3 cells with numerical data: case number, variable1, variable2. The text file has only one number on each line. So the format of the text file is: case number variable 1 variable 2 case number variable1 variable2 case number.... (where CR is a carraige return or line break) How can I read this in so first three numbers are in row one, next three in row 2, next three in row 3... Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Excel 2002 importing file origin is in japanese... | Excel Discussion (Misc queries) | |||
Importing text file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |