Inserting text into another text string

[sweetmetrics]

Ok, so I am very close to this and probably just need a pointer or two...

What I am using:
Excel for Mac 2011

What I Have:
300 rows of html text, exported from a website, that contain product titles

What I am trying to do:
Insert the word "Lenses" before the word "for" for each row. For example, the following is the beginning of text string(omitting the leading < to avoid editing the html of this actual post), the bold word is what I need inserted, "span style="font-size: 13pt; font-weight: bold; font-family: Verdana; color: rgb(0, 0, 0);">Ice Blue Lenses for Oakley Dispatch 1..."

What I've tried
=FIND("for",D2,1) to find the character number of "for" then I am stuck on which concatenating formula to use from here or if there is a better a way to insert the text?

Thank you in advance for your help!

 

[BenMiller]

An easy way might be to just do a find/replace (CTRL+H) and change "for" to "Lenses for" (without the quotes)

 

[BenMiller]

Or if you prefer a formula option, try =SUBSTITUTE(A1,"for","Lenses for")

Maybe even change it to =SUBSTITUTE(A1,"for","Lenses for",1) to control which instance you would like to change.