Quote:
Originally Posted by Don Guillett[_2_]
On Sunday, September 23, 2012 11:10:37 PM UTC-5, X82 wrote:
Hi guys.
I will try to explain this situation best I can.
I have about 500 .txt files. Here is a link to example files, 4 in
total.
https://docs.google.com/folder/d/0B0...ZKMWlSUGs/edit
The red parts of the files are the figure I need importing into excel.
So there is about 500 txt files with 4 different variations of the
file.
I also would like to import the filename of the txt file in a column. So
column A would read, AMAB3.txt and column B would be the figure pulled
from the txt file, say 1.9 or 5.6 etc. In a long list.
I'm sorry if I've explained this terribly and I will try to clear up any
issues. All help on this matter is appreciated.
--
X82
You could change from .rtf to .txt and then open in excel. Then you would need the logic of why 4.5 is the value you want from which file and why. Detailed logic.
|
The linked rtf files are only so I could append red marks for illustration purposes only. All 500 files are .txt files. How do you mean logic also?