Hello,

I have a list of 30k rows containing text strings.
I also have a list of 600 key words.
Each of the 30k rows only has 1 of the key words
I want to automate the process of searching the 30k rows for the key words and replacing the string with the key word it contained.


From what I can figure the solution to this is an excel Macro.

Can anyone help?

Thank you in advance.