| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing a text file of individual records
Hi,
take record1, copy, go to the column where you want the information, paste special transpose, do the same with record 2 "toby131" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing a text file of individual records
Thanks for the suggestion, but there are a few thousand records in this file,
is there any quicker way to get them into excel? "Eduardo" wrote: Hi, take record1, copy, go to the column where you want the information, paste special transpose, do the same with record 2 "toby131" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing a text file of individual records
You cannot do this in excel; however, you can make the *.txt file a *.CSV in
word 1) First replace all multiple paragraph marks between records with a text string that does not exist in your document. (i.e. replace "^p^p^p" with "zxc") 2) Replace headings with comma. (i.e. replace "^p Column 1 Header" with "," and the same for rest of columns) File will look like R1,C1,C2,C3,C4zxcR2,C1,C2,C3,C4 and so on... 3) Replace text string with paragraph (i.e. replace "zxc" with "^p") 4) Import into excel as a CSV file. "toby131" wrote: Thanks for the suggestion, but there are a few thousand records in this file, is there any quicker way to get them into excel? "Eduardo" wrote: Hi, take record1, copy, go to the column where you want the information, paste special transpose, do the same with record 2 "toby131" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
