Example: value iof cell A1 is “Mollis Foobar Egestas Lorem”

=IF(COUNTIF(1A,"*Foobar*"),"Yes","No")