Ask Your Question

Revision history [back]

The definition of word is indeed ambiguous, as in the example singular and plural should be found. If it is only about sub strings then this "simple" approach would do, without the not neglectable overhead of regular expressions, assuming string to be found in cell A1 and data in B1:B4

=SUMPRODUCT(IFERROR(SEARCH(A1;B1:B4)>=1;0);LEN(B1:B4)>LEN(A1))

This would also find cat in concatenate of course.