How to Extract the Text Between Brackets? Simple Guide!!
Tags: excelpreface, excelbasics, exceltutorials, findtextbetweenbrack
Published: 2021-01-20 11:52:46

---
title: How to Extract the Text Between Brackets? Simple Guide!!
published: true
date: 2021-01-20 11:48:22 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Findtextbetweenbrack
canonical_url: https://geekexcel.com/how-to-extract-text-between-brackets/
---

Assume that you have a list of data, and you need to **extract the text between the brackets (such as curly braces, square brackets, and parentheses)  in Excel**. How can you solve this task in a quick manner? Not to worry, just follow the steps in this article to solve it. Let’s see 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)
## Steps to find the text between brackets:

- If you want to get the data between two brackets, you need to create a formula based on **SEARCH** and **MID** functions. Let’s see the formula.

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

### Argument Explanations:

- **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.
- **MID** – This function will help 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/).

### Practical Example:

Please do as follows to find the text between brackets.

- Enter the input data on your worksheet.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-range-12.png)<figcaption id="caption-attachment-21287">Input range</figcaption>

- Then apply the given formula in the formula bar section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-18.png)<figcaption id="caption-attachment-21288">Enter the formula</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-38.png)<figcaption id="caption-attachment-21285">Result</figcaption>

## Bottom-Line:

In this short tutorial, we have described the simple steps to **find the text between two brackets in Excel Office 365**. Hope you like it. Please feel free to state your **query** or **feedback** for the above article. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/)!! **

### Related Articles:

- **[Combine Text from Two or More Cells into One Cell in Excel 365!!](https://geekexcel.com/combine-text-from-two-or-more-cells-into-one-cell-in-excel-365/)**
- **[Split Text String by Line Break in Excel Office 365!!](https://geekexcel.com/split-text-string-by-line-break-in-excel-office-365/)**