If the keywords are embedded within other characters, you probably need to use a FIND formula. Try:
=IF(ISERROR(FIND("example",A1,1)=TRUE),"NOT FOUND",FIND("example",A1,1))
(It's case sensitive)
The "iserror" just stops you getting a "#VALUE" error if it can't find the search field.
PS - in your case you'd substitute the word "example" with the cell reference of the word you're trying to find.