Forum menu
[Closed] Excel help. Finding specific words in cells?
Topic starter
I have a column with descriptions within cells.
I would like to identify where the description includes specific words - e.g. does cell contain and of the following words:
Tom, Dick or Harry
I have used = ISNUMBER(search("Tom", A2)) but that would only return where Tom exists. What do I need to do to return where cell contains either of Tom, Dick or Harry?
Thanks!
Posted : 08/06/2015 8:58 am
=ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH({"tom","dick","harry"},A2)),0))
Posted : 08/06/2015 10:34 am
Maybe useful to know that using "Mid" on the difference between your number and a "Find" (starting from your number) on the next occurrence of SPACE will pull those found words out for you.
But thats probably where you are going with this anyway
Posted : 08/06/2015 11:05 am