How to extract text between commas/brackets/parentheses in Excel?

Extracting specific text from a string in Excel is a common task, especially when dealing with data that includes delimiters like commas, brackets, or parentheses. Whether you're working with addresses, formulas, or structured text, this guide will walk you through the steps to extract text between these characters efficiently.

• Extract text between commas/brackets/parentheses with formulas
• Easily extract text between commas/brackets/parentheses with Kutools AI
• Easily extract text between same or different characters with Kutools for Excel

Extract text between commas/brackets/parentheses with formulas

♦ Extract text between commas

Please enter or copy the following formula into a blank cells, then, drag the formula down to apply it to other cells. See screenshot:

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

♦ Extract text between brackets/parentheses

If you want to extract the text between the brackets or parentheses, please apply the below formulas:

Extract text between parentheses

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

Extract text between brackets

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

Easily extract text between commas/brackets/parentheses with Kutools AI

"Kutools AI" is a feature within the "Kutools for Excel" add-on that simplifies many Excel tasks through automation. For extracting text between commas, brackets or other characters, "Kutools AI" eliminates the need to remember or understand complex formulas.

After installing Kutools for Excel, go to the "Kutools AI" tab and then select "AI Aide" to open the "Kutools AI Aide" pane.

1. Select the range of cells where you want to extract text between commas.
2. In the "Kutools AI Aide" pane, enter the following command in the edit box and press "Enter".
   Please perform the following action: Extract the text between commas in the selected range and place the result in the corresponding cell in column C.

   

3. "Kutools AI" then analyzes the command and provides a tailored solution. Please click the "Execute" button.

   

Then all texts between commas are extracted from the selected range immediately.

Easily extract text between same or different characters with Kutools for Excel

Tired of struggling with complex formulas to extract text between commas, brackets, or parentheses in Excel? "Kutools for Excel" offers a straightforward utility that allows you to extract text between any two specified characters, which can include commas or any other different markers. Please do as follows.

1. Click a cell where you want to output the result. Then, click "Kutools" > "Formula Helper" > "Formula Helper".

2. In the "Formulas Helper" dialog box, please do the following operations:

• Select "Text" option from the "Formula Type" drop down list;
• Then choose Extract strings between specified text" from the "Choose a fromula list" box as you need;
• In the Arguments input" section, select the cell containing the text you want to extract. Then, specify the start and end characters (e.g., commas, brackets, or parentheses) that define the text you wish to extract.
• Finall, click "OK" button.
  

Result: After getting the first result, then, drag the formula down to apply it to the other cells. See screenshot:

Extracting text between commas, brackets, or parentheses in Excel is a powerful skill that can save you time and improve data accuracy. By following the steps and tips in this guide, you’ll be able to handle even the most complex text extraction tasks with ease. If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials.

Relative Articles: