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

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

Formula | =FIND("(",A2) |
---|---|

Result | 16 |

**Step 2:** Find the location of right parenthesis

Formula | =FIND(")",A2) |
---|---|

Result | 41 |

**Step 3:** To decide the number of letters between parentheses

Formula | =FIND(")",A2)-FIND("(",A2)-1 |
---|---|

Result | 24 |

**Step 4:** To extract text between parentheses

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

Result | Data between Parentheses |

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

Thank you