Finding words in cell

I am looking for a formula that will allow me to find a certain word in a column of data. Specifically I want to find the cells that has the word 'Life Estate' in any cell in a particular column. I tried an if statement but could not get it to work. I want the answer to be either 'YES' or 'NO' in a separate column. How do I do that?

Assuming your text is in column A starting with A1, you can put this formula in cell B1:

=IF(ISNUMBER(SEARCH("Life Estate",A1)),"Yes","No")

and then copy down.

Hope this helps.

Pete

GREAT!! That worked wonderfully. Thank you for your help.