Hi May I request you all to help me for a macro to find and paste specific text from a word file into a new excel file.



The macro should copy any name which is appear either below or next to a text says "Name of person" however, do not pick any other rest of the words from the next paragraph onwards. Then paste the text nto a new Excel file.

Example:

"Name of person Dr. Peter Paul G"
"Voluntarily retired"

So, the macro should copy and paste into Excel only the word Dr. Peter Paul G

I have so many similar instances in my word document, so pls help me to extract