View Single Post
 
Old 01-28-2021, 11:44 PM
TA9523 TA9523 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2021
Posts: 8
TA9523 is on a distinguished road
Default Copy words from word to excel

Hi,
I have 300 docx files(file name ZXXX1 and etc.), which contains a lot information. I need to find in each document words which start with "1d-", "2d-", "1e-","1 d-", "2 d-",(letters can also be uppercase "1D-" etc.) and copy this words to excel with doc file name.
At the end, I should get the following Excel file with two columns:

|Doc file name| TAG|
|-------------|-------|
|zxxxx1|1d-xxx1|
|zxxxx1|2e-xxx1|
|zxxxx2|2D-xxxxxx1|
|zxxxx3|no matches|

-("no matches" if the file does not contain words starting with
these characters)
Thanks in advance to everyone who can somehow help me.
Reply With Quote