Countif tells me a word is within the is there, but I don't know wich word.
I would like the formula to find/search for multiple words and display the
word find.
PS. in any given cell will contain 1 of the words needed.

Thanks for your help

"JE McGimpsey" wrote:

One way:

If you're just checking for the presence of at least one of the words:

=SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0


In article ,
Titoto wrote:

is there a way to use the function 'FIND(OR)' to search for multiple words
within a cell