Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing a text file of individual records
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. 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 | |||
Splitting a text file into individual worksheets | Excel Discussion (Misc queries) | |||
Importing Text File Data into Excel where records span several row | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Importing file with fixed width, multi-line records | Excel Discussion (Misc queries) | |||
Help importing text files into individual cells | Excel Discussion (Misc queries) |