Thread: [Solved] Find paragraph matching an expression in Word and exporting to Excel spreadsheet
View Single Post
 
Old 11-03-2017, 08:38 AM
ballpoint ballpoint is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Sep 2017
Posts: 40
ballpoint is on a distinguished road
Default Find paragraph matching an expression in Word and exporting to Excel spreadsheet
Hi all,

I am looking to find a way to do the following, which I am not sure is even possible in Word / Excel. I tried to find a solution, but so far failed. Basically, I would need to:

  1. Search for the instances in which a particular word / expression / regex occurs in
  2. 2) several word files in a folder
  3. Find the matching paragraphs and copy them
  4. Paste them in an excel spreadsheet

Ideally, the resulting spreadsheet would have the name of the document in the first column, the search operator I used in the second, and the matching paragraphs in the third. Something like this, to be clear:

Code:
Document | Operator | Text

Doc 1       | Operator1| Matching text
Doc 2       | Operator1| Matching text
Is there any way to accomplish any of that?

Thank you very much!
Reply With Quote