+ Reply to Thread
Results 1 to 3 of 3

Extract text inside second bracket

  1. #1
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    233

    Extract text inside second bracket

    Hi

    Could you pls help me with the formula to extract the text inside the second pair of brackets?

    Yearly {Net Income (Adjusted)} (2003) - 1

    I would like the formula to return 2003.

    thanks

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Extract text inside second bracket

    Try this:

    =TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"(",")"),")",REPT(" ",200)),600,200))

  3. #3
    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: Extract text inside second bracket

    Or this
    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. How to extract cell text to other cell text in bracket
    By robinwindsor in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-03-2017, 08:31 PM
  2. Using VLOOKUP inside IFNUMBER(Search) to extract text in cell to lookup
    By MatrixRoland in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-11-2016, 02:45 AM
  3. Extract text to left of number of bracket
    By cmb80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2014, 06:57 PM
  4. Replies: 2
    Last Post: 07-18-2014, 03:00 AM
  5. extract capital words and bracket them
    By Hoonjin in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-16-2013, 02:45 AM
  6. Remove String Within the Bracket and also the Bracket
    By seanyeap in forum Excel General
    Replies: 6
    Last Post: 04-23-2010, 10:24 AM
  7. bracket text
    By kasuthar in forum Excel General
    Replies: 5
    Last Post: 12-26-2009, 08:21 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