Replace Text in a String

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.

Hey man, tanks a lot. It works nicely. I'm trying to deconstruct the formula... wondering how to make it work with longer or shorter text strings?

very difficult to understand, can anyone attach a example excel file here?

thanks

You can also use the SUBSTITUTE function for this:
A1>We sell gear for all fans
B1> Football gear
C1>=SUBSTITUTE(A1,"gear",B1)