How to Extract Data between Parentheses

To extract data between parentheses, you need to first find the location of left parenthesis and right parenthesis, then apply Mid Function.

• Extract Data between Commas
• Extract Data between Minus
• Extract Data between Brackets

Formula:

Copy the formula below and replace "A2" with the first cell that contains the text you would like to extract, then copy down.

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

Explanations:

Extract the data between parentheses from "How to Extract (Data between Parentheses)" from cell A2.

Step 1: Find the location of left parenthesis

Step 2: Find the location of right parenthesis

Step 3: To decide the number of letters between parentheses

Step 4: To extract text between parentheses

Step 5: In case there are extra spaces before or after the extracted data, use Trim function to remove them.

Download Example