+ Reply to Thread
Results 1 to 8 of 8

How to extract text between brackets/parentheses in Excel?

  1. #1
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    How to extract text between brackets/parentheses in Excel?

    ??? 2.jpg

    How to extract text between brackets/parentheses in Excel?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: How to extract text between brackets/parentheses in Excel?

    Hiii Done... see attached sheet

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: How to extract text between brackets/parentheses in Excel?

    b2=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,LEN(A2)-1),"(",REPT(" ",25)),"[",REPT(" ",25)),25))
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to extract text between brackets/parentheses in Excel?

    [ ... deleted ... ]
    Last edited by sandy666; 10-19-2015 at 03:22 AM.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to extract text between brackets/parentheses in Excel?

    something wrong, I cannot edit my own post, so... ignore post above.

    my 2¢'s
    B2:
    Please Login or Register  to view this content.
    with CSE (Control+Shift+Enter)
    Last edited by sandy666; 10-19-2015 at 03:21 AM.

  6. #6
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: How to extract text between brackets/parentheses in Excel?

    Hi mangesh.mehendale

    Thank you

  7. #7
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: How to extract text between brackets/parentheses in Excel?

    Hi nflsales

    Wow! excellent.Thank you

  8. #8
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: How to extract text between brackets/parentheses in Excel?

    Hi sandy666

    That's all right.Thank you for your help.

+ 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. Extract Text in Parentheses From One Cell to Another
    By Dhyre in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-13-2020, 04:10 AM
  2. How to extract text in between LAST set of parentheses?
    By kioken in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-27-2015, 02:08 PM
  3. Replies: 13
    Last Post: 08-28-2014, 08:00 PM
  4. Replies: 1
    Last Post: 07-17-2014, 04:54 AM
  5. [SOLVED] extract data from within brackets
    By L.LEE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2014, 11:36 PM
  6. [SOLVED] Extracting all text from parentheses (including parentheses)
    By j4ke101 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-10-2013, 08:03 AM
  7. Replies: 6
    Last Post: 01-13-2011, 03:00 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