| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Data from Text Files
I知 looking for a excel macro the will extract the first 8 characters
in the first line of a text file and put that value in cell A1. Extract characters 9 thru 14 in the first line and put that value in cell B1. Then go to the last line in the file and extract characters 9 thru 14 and put that value in cell C1. Last I would like to run this formula in cell D1 =C1-B1+1. Some times I could have as many as 150 different file in my directory so I would like the macro to do this for every file in my directory. Sample Data: FLEX764D1000751 FLEX764D1000752 FLEX764D1000753 FLEX764D1000754 FLEX764D1000755 FLEX764D1000756 FLEX764D1000757 FLEX764D1000758 Extraction would reurn A B C D FLEX764D1 000751 000758 8 Thank for any help.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Data from Multiple Excel Files | Excel Discussion (Misc queries) | |||
| Help extract numerous text files and how to use avg formula | Excel Worksheet Functions | |||
| GetValue to extract data from closed files | Excel Programming | |||
| extract text from html files | Excel Discussion (Misc queries) | |||
| Extract Text From Multiple Word Files | Excel Programming | |||
Threaded Mode
