Urgent! Need help for copying specific text from Microsoft Words to Excel

Help Activities
, , ,
1

Hi I need help with copying specific text from multiple Microsoft Words to Excel :persevere:
Example:
Name: John M
Date: 25 April 2020

Every Microsoft Words have different name and date, I need only the names: John M and 25 April 2020 and paste it to Excel

I know there’s regex but is there any other methods? Thank youuuu!!!

2

Hi! Do you know the exact position where that text appears in Word? You can try to use substrings and indexes and substract the text you need.

If the data’s structured always like the one you mentioned, you can also search for the 'Name: ’ and 'Date: ’ strings and then use those as positions in order to extract what’s after them.