| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large text file
I have a text file of individual records with a similar format to what is
shown below. I want to import this into excel with one record per row and each line of the record in a seperate column. I have a few thousand entries so am trying to find an automated method. Is there a way to do this? Record 1 Column 1 Header: xxxxxxxx Column 2 Header: xxxxx Column 3 Header: xxxxxxx Column 4 Header: xxxxxx Record 2 Column 1 Header: xxxxxxxx Column 2 Header: xxxxx Column 3 Header: xxxxxxx Column 4 Header: xxxxxx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
| Can you save 1 sheet from a large file into another file? | Excel Worksheet Functions | |||
| why is my simple text file so large (22 kb) | Excel Discussion (Misc queries) | |||
| Query/Lookup in large list (text file) | Excel Discussion (Misc queries) | |||
| Importing a large text file | Excel Discussion (Misc queries) | |||
Threaded Mode
