Simulating A LIKE or CONTAINS Function in excel

If I have a column with records of text (approximately 15 words each record) and I want column B to display TRUE or FALSE (or a paramter of my choosing) if it contains a word of my choice how do I do this?

Is their a way of simulating a LIKE or CONTAINS function in excel.

Thanks for any help in adavance.

Try SEARCH() or FIND()

Find() is case-sensitive

e.g. =Search("Dog",A1) will look for Dog in A1 and show it's position...

you can add to it... =Isnumber(Search("Dog",A1)) will return TRUE/FALSE or

=If(Isnumber(Search("Dog",A1)),"Yes","No") to return your chosen words...

With
D1: (a word to search other cells for.....eg frisbee)
Try something like this:

Please Login or Register  to view this content.

Is that something you can work with?