Find multiple words in cell?
 

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.

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.

Find multiple words in cell?
 

Joe,

This will return TRUE if it finds both. To make it case sensitive change
SEARCH to FIND

=AND(SEARCH("Development",A1),SEARCH("JVM",A1))

Mike

"Joe H." wrote:

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.

Find multiple words in cell?
 

Another one:
=SUM(COUNTIF(A1,"*"&{"development","JVM"}&"*"))
This will return 0, 1 or 2 depending.

or if you want to see TRUE or FALSE:
=SUM(COUNTIF(A1,"*"&{"development","JVM"}&"*"))=2

Both of these don't worry about case (JVM=Jvm=jvm=jvM...)

Joe H. wrote:

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.

--

Dave Peterson

Find multiple words in cell?
 

Thanks Bob. I think I led you down the wrong path. I was using the "Find"
feature and did a "Find All" on the word "Development". It listed all the
rows that had a cell containing that word. I then tried to enter "Development
AND JVM" along with other variations but the Find function doesn't like
multiple words. I'll try the programmatic replies that you and others gave
but I think I'm in for some more work than I imagined.

Thanks again for your quick response.
--
Joe H.


"Bob Umlas" wrote:

=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.