Excel Formulas to Extract the Text Between the Parentheses ~ Easy Tips!!
Tags: excelformula, excelformulas
Published: 2021-06-19 03:08:58

---
title: Excel Formulas to Extract the Text Between the Parentheses ~ Easy Tips!!
published: true
date: 2021-06-10 07:54:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-the-text-strings-between-the-parentheses/
---

Have you ever tried to extract the text string which is placed inside the parentheses? Do you have any good methods for solving this task in Excel? Here we will show the formulas to **extract the text between the parentheses in Excel**. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Extract the text between parentheses](https://geekexcel.com/wp-content/uploads/2021/06/Extract-the-text-between-parentheses.png)](https://geekexcel.com/excel-formulas-to-extract-the-text-strings-between-the-parentheses/extract-the-text-between-parentheses/#main)<figcaption id="caption-attachment-46266">Extract the text between parentheses</figcaption>

## Generic Formula:

- Use the below formula to extract the text between the parentheses.

**=[MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(text,[SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(“(“,text)+1,SEARCH(“)”,text)-SEARCH(“(“,text)-1) **

## Syntax Explanations:

- **MID** – This function helps to extract the number (starting from the left side) or characters from the given string. Read more on the **[MID function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)**.
- **SEARCH** – In Excel, the [**SEARCH function**](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/) locates the character between two text strings and returns to the number of the starting position of the first text string from the first character of the second text string.
- **Text** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol is used to add the values.

## Practical Example:

Let’s consider the below example image.

- Here, we will enter the input text strings in **Column B**.
- Now we need to separate the text which is placed inside the parentheses.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-20.png)<figcaption id="caption-attachment-46267">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-28.png)<figcaption id="caption-attachment-46265">Enter the formula</figcaption>

- Finally, press the ** ENTER** key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-24.png)<figcaption id="caption-attachment-46264">Result</figcaption>

## Wrap-Up:

From this tutorial, you can get some clarification on how to **extract the text between parentheses in Excel**. Hope you like it. Please feel free to state your **query** or **feedback** for the above article.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Extract the Substring ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-extract-the-substring/)**
- **[Excel Formulas to Count specific word in a range ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-count-specific-words-in-a-range/)**
- **[How to Find the Approximate Match with VLOOKUP in Excel?](https://geekexcel.com/how-to-find-the-approximate-match-with-vlookup-in-excel/)**
- **[Excel Formulas to count specific characters in a cell ~ Quick Method!!](https://geekexcel.com/excel-formulas-to-count-specific-characters-in-a-cell/)**