+ Reply to Thread
Results 1 to 6 of 6

Finding terms in a cell

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    USA
    MS-Off Ver
    Excel2010
    Posts
    27

    Finding terms in a cell

    I am attemting to seach for the text "sale," "new," and "order." Is there a formula that I can use to give me a TRUE indicator if the cells I am looking in contains one of those 3 terms and a FALSE if is doesn't?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Finding terms in a cell

    Say we are examining a range of cells A1, B1, C1 and want to know if any of the three words appear at least once in the range. Try:

    =OR(ISNUMBER(FIND("sale",A1 & B1 & C1)), ISNUMBER(FIND("order",A1 & B1 & C1)), ISNUMBER(FIND("new",A1 & B1 & C1)))
    Gary's Student

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    USA
    MS-Off Ver
    Excel2010
    Posts
    27

    Re: Finding terms in a cell

    I'm actually searching for those terms in one single cell. I tried writing the formula as only using the cell I'm working in but it isn't working.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,632

    Re: Finding terms in a cell

    Examine the cell A1:
    =SUMPRODUCT(--ISNUMBER(SEARCH({"sale","new","order"},A1)))>0

  5. #5
    Registered User
    Join Date
    10-04-2013
    Location
    USA
    MS-Off Ver
    Excel2010
    Posts
    27

    Re: Finding terms in a cell

    Thank you much worked great

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: Finding terms in a cell

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding the average re-order date in terms of months
    By sanjay.wagjiani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2013, 11:31 AM
  2. Replies: 9
    Last Post: 11-03-2010, 11:42 AM
  3. Replies: 1
    Last Post: 07-05-2010, 11:39 AM
  4. finding multiple broad terms in columns then pasting entire rows to new sheet
    By thirdcoast in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2010, 03:19 AM
  5. Multiple terms in same cell?
    By ml20080424 in forum Excel General
    Replies: 8
    Last Post: 04-30-2008, 03:47 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1