| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Text Data to Excel
I have been struggling now for a few days, so time to ask the experts. My
problem is this; I have 46 txt files each in exactly the same format and layout each with different file names, I need to be able to open all the files in th efolder Without specifying file names, Then to be able to extract the 3rd and 46th line from each txt file, I then want to paste these 2 lines into a workbook leave a space and then paste the next 2 lines and so on, and finally the two lines will need formatted to "text to columns\fixed width\ can anyone help? many thanks David -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting data and text. | Excel Discussion (Misc queries) | |||
| Extracting Data from a string of text in a cell | Excel Worksheet Functions | |||
| Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
| extracting text data in a cell | Excel Worksheet Functions | |||
| extracting data from a text string of varying length | Excel Discussion (Misc queries) | |||
Threaded Mode
