Find keywords in column

A Rose

Hi,

Any formula to find certain keywords in a column, and if it has it should say "Yes" ?

I don't need to find any words, just key words,

i.e. to find in a column that has 12345 & 98765, find all with a 234 string, if found, display "Yes"

Thank you!

A Rose

=IF(CONTAINS

Thank you anyway!

A Rose

=IF(CONTAINS

Thank you anyway!

Genevieve P.

Hi @A Rose

Thanks for posting your solution! I'm glad you were able to find an answer to your question.

Cheers,

Genevieve