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

**reedersketer** · 07-09-2014, 02:17 PM

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?

**Pepe Le Mokko** · 07-09-2014, 03:04 PM

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

**reedersketer** · 07-09-2014, 03:50 PM

Thank you, that does the trick!

**AlKey** · 07-09-2014, 03:57 PM

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

=IFERROR(LEFT(B2,FIND("for",B2)-2),B2)

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract text from a string of text (amend formula to include new criteria)

Extract data from text string to columns

Extract data from text string

Extract number data string from text

[SOLVED] EXTRACT TEXT FROM TEXT STRING:The names are of variable length

Bookmarks

Bookmarks

Posting Permissions