Is there anyone such an application-CodePudding

(is there such a application software, macros, etc.) is to Excel in the first case the content of the cell, to find in the word, and the color of the tag specifies,

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

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,