extracting Values between brackets

[kirana2014]

Please help me with extracting Values between brackets

Marketing departement (237)reporting data

Result must be = 237

Thank you

[Glenn Kennedy]

If your solitary example is really representative of your real data... this will do it:

=LOOKUP(99^99,--MID(A1,FIND("(",A1)+1,ROW($1:$20)))

[kirana2014]

Thanks Glenn is working

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.