I'm trying to figure out if this will work in Excel. I need to replace 1 word in a string of text, however, I need to insert different words. So Control +H will not work for me.

Here's the string of text: We sell gear for all fans

That string is pasted into about 1500 cells in Column A. I need to replace the word "gear" with a more descriptive phrase based on the type of sport. So for hockey, it should be "hockey gear" and for football it should be "football gear" etc...

Column A has the string of text; Column B has the replacement phrases. How do I accomplish this in Excel?

Thanks in advance.