Function for searching textparts in cells

[luckypurchase]

Dear reader,

I like to search parts of texts in cells, for a true or false value.

example; cell A1 contains > misternoodle
cell A2 contains > misterdudeson
cell A3 contains > madamhello

I like to search for the part "mister" for a true value within the cells of colum A, furthermore A3 automatically becomes false.

Thank you in advance!

 

[T. Valko]

Dear reader,

I like to search parts of texts in cells, for a true or false value.

example; cell A1 contains > misternoodle
cell A2 contains > misterdudeson
cell A3 contains > madamhello

I like to search for the part "mister" for a true value within the cells of colum A, furthermore A3 automatically becomes false.

Thank you in advance!

Put this formula in column B and copy down as needed:

=ISNUMBER(SEARCH("mister",A1))