Test if a cell contains 2 words

=count(xmatch({"ab", "bb"}, textsplit("aa ab bb ba cc",{".",","," "},,1)))>=2

Built-in Functions

COUNT - The number of numerical values.
TEXTSPLIT - (2024) The text string split into multiple columns using delimiters.
XMATCH - (2021) The position of a value in a list, table or cell range.

Related Formulas

Test if a cell contains 1 word
Test if a cell contains 1 text string
Test if a cell contains 2 text strings