Excel Formulas to Extract the Text Between the Parentheses ~ Easy Tips!!

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

Generic Formula:

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

*=MID(text,SEARCH(“(“,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.

SEARCH – In Excel, the SEARCH function 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.

Select any cell and type the above-given formula.

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

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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Excel Formulas to Extract the Substring ~ A Complete Guide!!

Excel Formulas to Count specific word in a range ~ Easy Tutorial!!

How to Find the Approximate Match with VLOOKUP in Excel?

Excel Formulas to count specific characters in a cell ~ Quick Method!!