Or can be in word for excel the first the content of the cell, replacing the content of the corresponding to the second column of the cell,
See the following illustration
1

2

3

1 is the appearance of the word was looking for, and after the tag,
2 is the appearance of the text in the excel, (for) based on
3 is the final results,
Thank you for your attention
CodePudding user response:
In Word and Excel macro records began in 2003, 2003 manual complete the required function, the end of the record macros, press Alt + F11 key, check just record macro corresponding VBA code,CodePudding user response:
1. To find the content in Word, Ctrl + H, modify the format, the [more] TAB, can replace change font color, "in the Word search, and specifies the color,"
2. Certain requirements and Excel connection? If don't have to connect the Excel, but with the E data:
2.1 less data, directly find, replace all,
2.2 data, formatted search and search data, makes them Word inside the wildcard search, and replace,