Extract text between brackets using google spreadsheets

Question

I want to extract the text between brackets in a cell (X3), but the usual excel formulas give a parse error in google spreadsheets.

For example:

=MID(X3,FIND("[",X3)+1,FIND("]",X3)-FIND("[",X3)-1)

How to fix this parse error?

Thanks in advance.

Answer 1

You have regular brackets so use:

=REGEXEXTRACT(X3,"\((.*)\)")

Or change your formula to

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

If you have both () and [] in your data you can use:

=REGEXEXTRACT(X3,"[\[\(](.*)[\)\]]")