Search for a text in all the text files of a folder [Closed]

Report
Posts
1
Registration date
Wednesday May 27, 2015
Status
Member
Last seen
May 27, 2015
-
I have about 200 text files with different names that gets stored in a folder. What I want is when a specific word is found (ex error, fault). I want excel to mention true or false next the text file name which is in column A.

Name Error Found
Textfile1 TRUE
Textfile2 FALSE
Textfile3 TRUE
Textfile4 TRUE
Textfile5 TRUE
Textfile6 TRUE
Textfile7 TRUE
Textfile8 TRUE
Textfile9 TRUE
Textfile10 FALSE
Textfile11 FALSE
Textfile12 FALSE
Textfile13 FALSE
Textfile14 FALSE

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!