How to Remove Parentheses in Excel (5 Simple Methods)

Parentheses in Excel often appear when data is imported or copied from external sources. It makes your spreadsheet look cluttered and inconsistent. For example, you might have names like John Doe (Manager) or product labels such as Widget X (Old). These extra brackets can interfere with sorting, filtering, or matching data accurately.

In this article, you’ll learn how to remove parentheses in Excel step by step using different methods.

Key Takeaways

Here’s how to remove parentheses in Excel using SUBSTITUTE function:

➤ Open your dataset in Excel.
➤ Click on cell B2 where you want to display cleaned text of cell A2.
➤ Enter the following formula:
=SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")
➤ Press Enter. Excel will remove both opening and closing parentheses from the text in A2.
➤ Drag the fill handle down to apply the formula to the rest of the rows.
➤ After applying this formula, your cleaned data will be displayed in Column B.

What Are Parentheses in Excel?

Parentheses are round brackets ( ) that often appear around words, numbers, or notes in Excel cells. They are commonly used to add extra information such as job titles, product versions, or short comments. For example, a cell might contain John Doe (Manager) or Product X (Discontinued).

Although they help clarify details, parentheses can sometimes make your data harder to process or analyze. Removing them can simplify your dataset and make it easier to work with formulas, filters, and reports.

In this following dataset, Column A contains Raw Text that includes parentheses; Column B is empty where we’ll apply one or more of the methods to clean the text.

The Find & Replace tool is the easiest and fastest method to remove parentheses in Excel. It works well when you simply want to delete the ( and ) characters from your text. This method does not require any formulas and can be completed in a few simple steps.

Here’s how to do it:

➤ Open your dataset in Excel.
➤ Select the range of cells that contain the parentheses. For example, select A2:A10.
➤ Press Ctrl + H to open the Find and Replace dialog box.
➤ In the Find what box, type ( and leave the Replace with box empty.
➤ Click Replace All to remove all opening parentheses. Then, click Ok.

➤ Repeat the same steps for closing parentheses. Type ) in Find what and leave Replace with blank, then click Replace All again.
➤ Click Ok.

➤ After these steps, all parentheses will be removed from the selected cells.

The SUBSTITUTE function is a simple and reliable way to remove parentheses using a formula. It replaces specific characters in a cell with something else. This method keeps your original data safe and creates a clean version in another column.

Here’s how to do it:

➤ Open your dataset in Excel.
➤ Click on cell B2 where you want to display cleaned text of cell A2.
➤ Enter the following formula:

➤ Press Enter. Excel will remove both opening and closing parentheses from the text in A2.

➤ Drag the fill handle down to apply the formula to the rest of the rows.
➤ After applying this formula, your cleaned data will be displayed in Column B.

The Flash Fill feature in Excel is another simple and smart way to remove parentheses. It automatically recognizes patterns based on your example and fills the rest of the column accordingly. This method is perfect when you want to clean up text without writing any formulas.

Here’s how to do it:

➤ In cell B2, type the cleaned version of the first entry manually.
➤ For example, if cell A2 contains John Doe (Manager), type John Doe Manager in B2.
➤ Press Enter to confirm.

➤ Now go to cell B3, and press Ctrl + E on your keyboard. This activates Flash Fill.
➤ Excel will automatically detect the pattern and fill the rest of the column by removing the parentheses in each entry.

Sometimes you may want to remove not only the parentheses but also the text inside them. For example, turning John Doe (Manager) into John Doe. Excel can handle this using a combination of text functions such as LEFT, FIND, and IFERROR.

Here’s how to do it:

➤ Click on cell B2.
➤ Enter the following formula:

➤ Press Enter. The formula will remove everything starting from the first opening parenthesis.

➤ Drag the fill handle down to apply the formula to the remaining rows.

If you work with large datasets and need to remove parentheses frequently, using a VBA macro can save a lot of time. A macro can automatically go through all selected cells and delete parentheses in one click. This method is ideal for repetitive or large-scale cleanups.

Here’s how to do it:

➤ Press Alt + F11 to open the VBA editor.
➤ Click Insert on the menu bar, then select Module.
➤ In the module window, copy and paste the following VBA code:

Sub RemoveParentheses()
    Dim rng As Range
    Dim cell As Range
    Set rng = Selection
    For Each cell In rng
        cell.Value = Replace(cell.Value, "(", "")
        cell.Value = Replace(cell.Value, ")", "")
    Next cell
End Sub

➤ Close the VBA editor and return to your Excel worksheet.
➤ Select the range of cells that contain parentheses. For example, A2:A10.
➤ Press Alt + F8 , choose RemoveParentheses, and click Run.

➤ After running the macro, all parentheses in the selected cells will be removed instantly.

Downloadable Resources

Get our practice workbook or necessary files that we have worked with to prepare this article.

Wrapping Up

Removing parentheses in Excel helps keep your data clean and easier to manage. It becomes especially useful when working with imported files, employee lists, or product details that include extra notes in brackets. Cleaning these up makes sorting, filtering, and reporting more accurate.

Applying this cleanup improves efficiency in handling your data and gives your worksheet a polished, organized appearance. It keeps text consistent and makes it easier to analyze, share, or present without extra symbols interfering.