Find/Search or similar function

  • Thread starter Thread starter anupam
  • Start date Start date
A

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
 
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
 
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
Click to expand...

=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
 
Back
Top