View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default Find multiple words in cell?

=AND(NOT(ISERROR(FIND("development",A1))),NOT(ISER ROR(FIND("JVM",A1))))
Bob Umlas
Excel MVP

"Joe H." wrote in message
...
I hate to even ask but is it possible to find if two or more words are
found
in a text cell.

For example I want to find if a particular cell contains the words
"development" AND "JVM"

Thank you.

-
Joe H.