SEARCH(find_text,within_text,start_num)
It depends on how you're using it:
=OR(ISNUMBER(SEARCH({"blue","red"},B2)))
--
Biff
Microsoft Excel MVP
"dangerd" wrote in message
ups.com...
Hi there,
Is there a way to specify the 'find_text' to be one of a selection of
strings? For instance:
SEARCH("blue" or "red",B2,1)
To look for either the words blue or red/
Thanks
|