+ Reply to Thread
Results 1 to 4 of 4

how to detect a part of a phrase?

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    Edinburgh
    MS-Off Ver
    Excel 2010
    Posts
    17

    how to detect a part of a phrase?

    Hi all
    I am trying to implement an if formula in cell B1 and for the logic part i want to detect if cell A1 contains either "unallowed" or "incomplete" these are part of numerous phrases which also contains other text.

    I hope you understand and thanks for any help
    Kello
    Last edited by kello99; 11-25-2012 at 10:05 AM.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: how to detect a part of a phrase?

    Try..

    =OR(ISNUMBER(SEARCH("incomplete",A1)),ISNUMBER(SEARCH("unallowed",A1)))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    Edinburgh
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: how to detect a part of a phrase?

    hi Ace_XL
    Thanks for your help
    Although your formula will check for those words i need to get it to work in an IF fuction as i have other arguments which needs to be included.
    I have the formula working for the rest but having trouble trying to include these to points
    any other ideas
    Thanks
    kello

  4. #4
    Registered User
    Join Date
    10-11-2012
    Location
    Edinburgh
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: how to detect a part of a phrase?

    I have solved this issue by rearranging the spreadsheet a little bit, and used the if Function to look up for a complete phrase

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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