Page 1 of 1

MS Excel - Formula To Find If A String Contains ...

Posted: Sat Nov 14, 2015 12:28 pm
by magicrat
Yields a boolean result ...

Example below searches for the character "@" in cell D2 ... and returns "Yes" if found.

=IF(ISNUMBER(SEARCH("@",D2)), "Yes", "No")