+ Reply to Thread
Results 1 to 5 of 5

extract data from within brackets

  1. 03-16-2014, 11:07 PM #1
    L.LEE
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    234

    extract data from within brackets

    Hi

    I have cells that contain data within brackets [ ]. Is there a way to extract into another cell only the data within the brackets?

    I attach the sample file.

    thanks

    LL
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-16-2014, 11:17 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: extract data from within brackets

    Try this:

    =MID(A2,FIND("[",A2),LEN(A2)-FIND("[",A2))
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 03-16-2014, 11:20 PM #3
    L.LEE
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    234

    Re: extract data from within brackets

    Hi, may I remove even the [] and left with just the alphabets?
    Reply With QuoteRegister To Reply
  4. 03-16-2014, 11:32 PM #4
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: extract data from within brackets

    Change to:

    =SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("[",A1),LEN(A1)-FIND("[",A1)),"[",""),"]","")
    Reply With QuoteRegister To Reply
  5. 03-16-2014, 11:36 PM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: extract data from within brackets

    =mid(a2,find("[",a2)+1,find("]",a2)-find("[",a2)-1)
    Last edited by martindwilson; 03-16-2014 at 11:39 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract multiple occurrences of text within brackets from a cell
    By danminsh in forum Excel General
    Replies: 13
    Last Post: 08-28-2014, 08:00 PM
  2. [SOLVED] How to extract data from brackets, [xx] and amend them?
    By eldarchen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 09:56 AM
  3. How to extract the last part of the column that appears in square brackets
    By yapema in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2012, 06:59 PM
  4. find and extract the numbers in between brackets
    By kwfine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2011, 04:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1