Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Does a cell contain a particular text?

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Does a cell contain a particular text?

    What is the easiest way to determine if for Cell A1 contains a particular text? The cell most likely will contain one or two 2 to 3 character words separated by commas I don't care where my search text is in the cell, I just want to know is it there?

    Thanks

  2. #2
    New Member
    Join Date
    Nov 2015
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    Meant to write . . . "if Cell A1". . . . . .

  3. #3
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    Try

    =COUNTIF(A1,"*particulartext*")>0

    True means particulartext exists within A1
    False means it doesn't.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  4. #4
    New Member
    Join Date
    Dec 2015
    Location
    Atlanta, GA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    This will return FALSE when the string of interest in not found, TRUE when it is.

    Code:
    =ISNUMBER(SEARCH("stringofinterest",A1))
    NOTE: the above formula is NOT case sensitive. If you prefer the string of interest to be case sensitive, replace SEARCH with FIND.

  5. #5
    New Member
    Join Date
    Dec 2015
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    For a more visual method you could use conditional formatting Format Excel cells which contain specific text – Excel Whizz

  6. #6
    New Member
    Join Date
    Nov 2015
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    That will work. Thank you.

  7. #7
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Does a cell contain a particular text?

    You're welcome.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •