Extract Text from String where text starts and finishes with brackets

[Paul Whitaker]

Is there a simple formula that can extract text from a string, when the text required starts with an Opening Bracket "(" and finishes with a closing bracket ")". The text can be of different length and the output needs be be excluding the brackets.


Thank you


Paul

 

[jason]

Probably not the best.... but seems to work


=MID(A1,FIND("(",A1,1)+1,SUM(FIND(")",A1,1),-FIND("(",A1,1),-1))

 

[Luke M]

Simplifying Jason's formula a little:

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

 

[Paul Whitaker]

Thank you to both Jason and Luke M. Very quick response times and exactly the formula I was looking for.

 

[shrivallabha]

Here's one more:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"(",REPT(" ",100)),")",REPT(" ",100)),100,100))