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...