+ Reply to Thread
Results 1 to 4 of 4

Extract text from a given point in a text string, when data points do not share the given

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    kansas city, mo
    MS-Off Ver
    Excel 2010
    Posts
    42

    Extract text from a given point in a text string, when data points do not share the given

    I have a set of task descriptions that I am attempting to trend on. Some of these (Column B) have the customer’s name added to the description; others do not. I need to be able to make a list of task names (ColumnA), removing the name from the text string. The formula I am using is [=LEFT(B3,FIND("for",B3)-2)]. The problem I am having is when the description does not contain the “for” built into the formula, I get “VALUE” error. What adjustment can I make to the formula to pull over the Description if the “for” does not appear in the text string?
    Attached Files Attached Files

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,741

    Re: Extract text from a given point in a text string, when data points do not share the gi

    Perhaps =IF(ISNUMBER(FIND("for",B2)),LEFT(B2,FIND("for",B2)-2),B2) Be aware FIND is case sensitive ( use SEARCH if necessary)

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    kansas city, mo
    MS-Off Ver
    Excel 2010
    Posts
    42

    Thumbs up Re: Extract text from a given point in a text string, when data points do not share the gi

    Thank you, that does the trick!

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

    Re: Extract text from a given point in a text string, when data points do not share the gi

    Acutally, your original formula is correct. It just needed small modification

    =IFERROR(LEFT(B2,FIND("for",B2)-2),B2)
    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] Extract text from a string of text (amend formula to include new criteria)
    By robertguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2013, 04:53 PM
  2. Extract data from text string to columns
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2012, 09:12 AM
  3. Extract data from text string
    By bigband1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2011, 04:55 AM
  4. Extract number data string from text
    By lamatao in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2009, 04:27 PM
  5. EXTRACT TEXT FROM TEXT STRING:The names are of variable length
    By carricka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2005, 06:05 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