Get the characters in between ()

[zinah]

Hi,

I need a formula that can get the characters in between the ( ), is there any recommendation? Here's the a sample table:

Current Name​	Results​
AA BB (227501AA)​	227501AA​
A BBD (227501BA)​	227501BA​
AAC BBS (CC7501AA)​	CC7501AA​
AA DDAA (117501AA)​	117501AA​

Thank you!

 

[Fluff]

How about

=MID(SUBSTITUTE(A2,")",""),FIND("(",A2)+1,100)

 

[alansidman]

AN alternative is to use Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Extracted Text Between Delimiters" = Table.TransformColumns(Source, {{"Current Name", each Text.BetweenDelimiters(_, "(", ")"), type text}})
in
    #"Extracted Text Between Delimiters"

 

[Rick Rothstein]

If, as your examples show, the value you want to retrieve is always 8 characters long, then this can be used...

=MID(A1,FIND("(",A1)+1,8)

 

[zinah]

How about

=MID(SUBSTITUTE(A2,")",""),FIND("(",A2)+1,100)

Thank you so much that worked perfectly great!

 

[zinah]

If, as your examples show, the value you want to retrieve is always 8 characters long, then this can be used...

=MID(A1,FIND("(",A1)+1,8)

Thank you so much Rick!

 

[zinah]

AN alternative is to use Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Extracted Text Between Delimiters" = Table.TransformColumns(Source, {{"Current Name", each Text.BetweenDelimiters(_, "(", ")"), type text}})
in
    #"Extracted Text Between Delimiters"

Thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[alansidman]

You are welcome.