wildcard search in if formula

[punchedin]

I'm trying to find a formula that will look in cell A1 and if it has th
word "yes" to return the word sign in cell B1. This is what I have bu
it doesn't work.

if(A1="*sign*","yes","no")

Thank

 

[Andy B]

Hi

In B1 try:
=IF(A1="*yes*","sign","")