Text "comparison" operator for "contains" used in an "IF" Function
You can use the FIND function and test for a (non-) error result (ISERROR)
--
Kind regards,
Niek Otten
"Pawaso" wrote in message
...
I'm trying to use an "IF" function to look for a certain word in a string
of
text. Is there a "contains" operator for this?
I tried using =if(A1="*example*","yes","no") but this does not seem to
work.
|