+ Reply to Thread
Results 1 to 6 of 6

If certain text is found at the beginning of a string return an X

  1. #1
    Forum Contributor JulianS96's Avatar
    Join Date
    11-01-2019
    Location
    England
    MS-Off Ver
    365 (work-99%), 2016 (home-1%)
    Posts
    238

    If certain text is found at the beginning of a string return an X

    Hello forum,
    Now I've come to learn quite a few things thanks to this forum over the past few weeks, with a specially strong function being the IF(ISNUMBER(SEARCH combo.

    However, I am having trouble letting excel no the difference between some select cells.
    A sheet will better explain this but I want excel to find text at the BEGINNING of the TEXT STRING, and NOT anywhere within the text.

    Please find attached to see what I mean.
    Cheers,
    Julian
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,651

    Re: If certain text is found at the beginning of a string return an X

    if you are wanting only text strings at the beginning then maybe this... =IF(OR(LEFT(B7,8)="KAK WELL",LEFT(B7,4)="BUTT",LEFT(B7,4)="FILL"),"X","")
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,879

    Re: If certain text is found at the beginning of a string return an X

    You can use the LEFT function, like this:

    =IF(OR(LEFT(B4,8)="KAK WELL",LEFT(B4,9)="BUTT WELL",LEFT(B4,4)="FILL"),"X","")

    I put this in D4, so that you can easily compare the results with what you have in column C.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor JulianS96's Avatar
    Join Date
    11-01-2019
    Location
    England
    MS-Off Ver
    365 (work-99%), 2016 (home-1%)
    Posts
    238

    Re: If certain text is found at the beginning of a string return an X

    Thanks to both you Pete and Sambo kid. I was thinking that it would have to be some sort of text extraction method like LEFT. That'll do the trick Thanks guys!
    Last edited by JulianS96; 12-04-2019 at 12:39 PM.

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,651

    Re: If certain text is found at the beginning of a string return an X

    you're welcome, glad I could be of help. AND thank you for the rep!
    Last edited by Sam Capricci; 12-04-2019 at 12:38 PM.

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: If certain text is found at the beginning of a string return an X

    Here is another one

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. [SOLVED] IF range of cells contains string of text, return contents of cell where string is found
    By nobodyukno in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-03-2013, 09:56 AM
  2. Move Text From End Of String To Beginning
    By Tellm in forum Excel General
    Replies: 4
    Last Post: 06-28-2013, 06:09 AM
  3. Removing Spaces at the Beginning and/or End of a Text String
    By olives in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2013, 06:55 PM
  4. [SOLVED] Script or formula to move text from beginning to end of a string
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2012, 10:18 AM
  5. [SOLVED] VBA expression to extract the text from the beginning of an alphanumeric string
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2012, 12:41 AM
  6. Removing numbers from the beginning of a text string
    By Night Owl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2005, 01:06 PM
  7. [SOLVED] Search column - return row found in long text string
    By JayL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2005, 12:06 AM

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