Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • Excel help. Finding specific words in cells?
  • benz
    Free Member

    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 8 years ago
    Rubber_Buccaneer
    Full Member

    =ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH({“tom”,”dick”,”harry”},A2)),0))

    Posted 8 years ago
    jam-bo
    Full Member

    http://www.techonthenet.com/excel/formulas/find.php

    Posted 8 years ago
    samunkim
    Free Member

    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 8 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘Excel help. Finding specific words in cells?’ is closed to new replies.

Overview Chat Bike Members News Women