+ Reply to Thread
Results 1 to 2 of 2

Formula to extract data within Brackets from text string

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Formula to extract data within Brackets from text string

    Hello again, I have another query regarding extracting data from a text string.

    Some of my data has brackets after it and some doesn't. Example in the sheet attached

    In column A I have the data.

    I would like a formula to extract in column B the fruit
    And then in column C - the word within the bracket (Not including the bracket). If there is no bracket then put NA

    Thanks for any help on this
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Formula to extract data within Brackets from text string

    To return fruit

    =LEFT(A1,FIND(" ",A1)-1)

    To return word in brackets

    =IF(ISERROR(FIND("(",A1)),"NA",MID(A1,FIND("(",A1)+1,FIND(")",A1)-(FIND("(",A1)+1)))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Replies: 13
    Last Post: 08-28-2014, 08:00 PM
  2. [SOLVED] Extract text from a given point in a text string, when data points do not share the given
    By reedersketer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2014, 03:57 PM
  3. [SOLVED] extract data from within brackets
    By L.LEE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2014, 11:36 PM
  4. [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
  5. How to extract a string within brackets repeatedly
    By wussupbuddy in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-11-2008, 10:38 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