I"m not quite sure where you're going with your request, but in my
experiments I came up with something you might be able to use:

Here's an example:
A1: The quick brown fox
A2: The quick fox
A3: The fox
A4: The dog

This case-insensitive formula checks if the text contains BOTH "quick"
and "fox"
B1: =SUMPRODUCT(--ISNUMBER(SEARCH({"quick","fox"},A1)))=2

If you need case-sensitive, then:
B1: =SUMPRODUCT(--ISNUMBER(FIND({"quick","fox"},A1)))=2

Copy/paste that formula down through B4.

Results:
B1: TRUE
B2: TRUE
B3: FALSE
B4: FALSE

Something you can use?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=516690