LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I find all possible combinations of words? Yvonne Excel Worksheet Functions 4 June 6th 08 01:19 AM
counting text example of a cell with multiple words inside steveo Excel Discussion (Misc queries) 1 June 6th 06 04:47 AM
counting text example of a cell with multiple words inside steveo Excel Discussion (Misc queries) 0 June 6th 06 03:30 AM
Need to find the 1st two characters of the 1st two words Tom Excel Worksheet Functions 2 April 21st 05 02:10 AM
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell Tourcat Excel Worksheet Functions 1 February 8th 05 06:26 PM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"