how to extract text between parentheses


Hi Smarthseet community,

Can you help to figure out how to extract text between two parentheses?

For example, ABCD(12345), I would like to extract 12345 in a different cell.

Here is my formula: =MID([email protected], FIND("(", [email protected] + 1, FIND(")", [email protected]) - FIND("(", [email protected]) - 1)))

It gave me "UNPARSEABLE" error message.

Any suggestions are well appreciated!!

Best Answer


Sign In or Register to comment.