how to extract text between parentheses

SHUIYI THAMES · 02/22/21

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!!

Mark Cronk · 02/23/21

Try:

=MID(Item@row, FIND("(", Item@row)+ 1, FIND(")", Item@row) - (FIND("(", Item@row) - 1))

Mark

Mark Cronk · 02/23/21

Try:

=MID(Item@row, FIND("(", Item@row)+ 1, FIND(")", Item@row) - (FIND("(", Item@row) - 1))

Mark

SHUIYI THAMES · 02/23/21

Thanks, Mark! It works!

Shuiyi

Mark Cronk · 02/24/21

Hi, Glad you found a solution. Thank you for contributing to the Community.

Mark

Laura Saldivar Ovalle · 03/28/22

Mark, what about a formula to eliminate the parenthesis text and order?

Ex: Perez (10148), Madison , I need to be "Madison Perez". Looking for a formula to do it.

Best Answer