| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vba code for excel to extract data from txt file
USING Excel 2000.
I have a text file that when viewed in excel lists the entire row of data in one cell. I cannot parse data because each line does not have the same break. I want to extract the fields into individual cells. I will need to define "what" I am looking for. Is there sample vba code for excel I can reference to learn how this may be done? sample report REF #:A1B CUSIP:12345678 TD:1/1/00 SYMBOL:ABC QTY: 1 SD:01/03/00 ACME COMPANY PRICE: 9.101 MKT:OTC want to extract REF# TD SD CUSIP MKT SYMBOL FIELD1 QTY PRICE PRICE A1B 1/1/00 1/3/00 12345678 OTC ABC ACME COMPANY 1 9.101 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create links to extract data from one excel file to another excel | Excel Worksheet Functions | |||
| how do i extract data from pivot table to txt file | Excel Discussion (Misc queries) | |||
| How do I extract an Excel Chart as a graphics file? | Excel Worksheet Functions | |||
| Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
| Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) | |||
Threaded Mode
