| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
converting line-delimited text into cells
I have a text file with approximately 1000 lines of data, each line is 100
chars or less. The first 15 lines are column headers (some columns are unused), then every 12 subsequent lines is one record. What is the easiest way to get each record to appear in Excel (2007) on a single line, one field per column? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate a TAB When Converting From Excel to Delimited Text | Excel Discussion (Misc queries) | |||
| Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
| Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
| Why can't I Export selected cells to tab-delimited text file? | Excel Discussion (Misc queries) | |||
| Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
Threaded Mode
