Find/Search or similar function

[anupam]

i want 2 search 2 or more text with in another text without using i
function, how to do?

eg i want to search bfg1 or gkm2 in another text abfg1234 at the sam
time i dont want to use if function to do this. Is it possible to d
with in find funtion using "or" or anyther other wa

 

[JulieD]

AFAIK you can't use an OR in a SEARCH or FIND functions, any particular
reason for not wanting to use the IF function?

Cheers
JulieD

 

[hgrove]

anupam wrote...
...

eg i want to search bfg1 or gkm2 in another text abfg1234 at
the same time i dont want to use if function to do this. Is it
possible to do with in find funtion using "or" or anyther other
way

=OR(SUBSTITUTE(BigString,{"bfg1";"gkm2"},"")<>BigString)*
MIN(FIND({"bfg1";"gkm2"},BigString&{"bfg1";"gkm2"}))

But it's hard to see any advantage over formulas using IF