Results 1 to 4 of 4

Thread: Search formula with continued text
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2008
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Search formula with continued text

    Hi - need help on "Search" formula. Below is the example. When I put the search formula in B1 and B2 it shows the same result as the text continues

    what I am looking is in B2 it should return error as "Term1" is not there in A2. could you please help how to do it? Thanks,

    Column A Column B Result in col B
    Term1 =SEARCH("Term1",A1) 1
    Term16 =SEARCH("Term1",A2) 1

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Location
    Syria
    Posts
    328
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on search formula with continued text

    Hi
    Try
    Code:
    B1=FIND("Term1";A1)
    B2=FIND("Term1";A2)
    Last edited by mohadin; Oct 23rd, 2019 at 05:22 AM.

  3. #3
    Board Regular
    Join Date
    Mar 2008
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on search formula with continued text

    Hi tried the above code, still result is same.

    as "Term1" contains in "Term16" the formula is reading only first few characters to match the result as son as it finds.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,177
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: Help on search formula with continued text

    How about
    =SEARCH("Term1 ",A1&" ")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

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
  •