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(Item@row, FIND("(", Item@row + 1, FIND(")", Item@row) - FIND("(", Item@row) - 1)))
It gave me "UNPARSEABLE" error message.
Any suggestions are well appreciated!!