Another one:

=if(countif(a1,"*happy*")0,"yep","nope")


J@Y wrote:

If I have a sentence in a cell, what code can I use to search a word in that
cell?
Eg: A1: "I am happy"
I want to test if A1 has the word "happy" in it.

--

Dave Peterson