To strip parentheses out of a cell, nest two SUBSTITUTE functions — one for each bracket: =SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""). The inner one removes the opening bracket and the outer one works on that result to remove the closing bracket.
For a one-off cleanup with no formula, select the range, press Ctrl+H, put ( in “Find what”, leave “Replace with” empty, click Replace All, then repeat for ). Two things to be careful of.
Find and Replace changes the cells permanently, so work on a copy if you might need the originals — and if you leave the range unselected it runs across the whole sheet, including any formulas that contain brackets.
If you also want to remove the text inside the brackets rather than just the brackets themselves, SUBSTITUTE won’t do it: use =TRIM(LEFT(A1,FIND("(",A1)-1)&MID(A1,FIND(")",A1)+1,LEN(A1))), or in Excel 365, =REGEXREPLACE(A1,"s*([^)]*)","").
You can use the find and replace dialog box to remove brackets from a range of cells or even from a single cell in Excel. You can specify the bracket that you want to replace and a blank value to replace it with.

In this tutorial, we will look at a few ways to remove brackets from values in Excel.
Steps to Remove Brackets in Excel (Find and Replace)
You can use the following steps:
- First, select the range of cells from where you want to remove the brackets.

- After that, use the keyboard shortcut Ctrl + H to open the find and replace option.

- Now, enter the opening parenthesis “(” in the Find what input bar, leave the Replace with input bar blank, and then click Replace All.

- This will replace the opening parentheses with a blank value.

- From here, you need to remove the closing parentheses as well. So enter the closing parenthesis “)” in the Find what input bar and leave the Replace with input bar blank.

- In the end, click Replace All to replace it.

This is a two-step method where you remove the opening bracket and the closing bracket.
Be careful with the selection here. If it includes cells with formulas, Find and Replace also looks inside the formulas (Look in: Formulas is the default) and tries to remove their brackets, which breaks them. So select only the cells with the values.
Also, if negative numbers show in brackets, like (250), that comes from the number format, not from the value. Find and Replace can’t find those brackets; change the number format instead (Home ➜ Number ➜ Number, and pick the -1234 option).
Formula to Remove Brackets in Excel
You can also use a formula to remove brackets from a cell or a range of cells. And for this, you need to use the Excel SUBSTITUTE function.

=SUBSTITUTE(SUBSTITUTE(A1,”(“,””),”)”,””)
With SUBSTITUTE, you can refer to a cell, specify a value you want to replace, and a new value to replace it with. Here you have two SUBSTITUTE functions; one is wrapping the other. The first removes the opening bracket:

And then, the second SUBSTITUTE removes the ending bracket using the value returned by the first SUBSTITUTE.

VBA Code
You can also use a VBA code to remove the parentheses from the selected cells.
Sub remove_parenthese() 'this will replace the starting parentheses. Selection.Replace What:="(", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False 'this will replace the ending parentheses. Selection.Replace What:=")", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub
You need to select the cells and then just run this code.
Like the manual method, the Replace method in this code also changes formulas in the selected cells, so select only the cells with values.
Remove Brackets and the Text Inside Them
Sometimes you want to remove the brackets along with what’s in them, like “John (Sales)” to “John”. With Find and Replace, enter (*) in Find what and leave Replace with blank. The asterisk is a wildcard that matches any text between the brackets.
And with a formula, take the text before the opening bracket. Adding “(” to the end of the cell inside FIND makes the formula return the full text when there’s no bracket, instead of an error:
=TRIM(LEFT(A1,FIND("(",A1&"(")-1))
Extract the Text Inside the Brackets
To do the opposite and get only the text between the brackets, use MID with two FIND functions. For “John (Sales)”, it returns “Sales”, and IFERROR returns a blank when the cell has no brackets:
=IFERROR(MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1),"")
Remove Square and Curly Brackets
The same SUBSTITUTE idea works for other kinds of brackets. Just add one SUBSTITUTE for each character you want to remove:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]",""),"{",""),"}","")
In Excel for Microsoft 365, you can also use REGEXREPLACE with a pattern for all the brackets at once, like =REGEXREPLACE(A1,”[()\[\]{}]”,””).
Frequently Asked Questions
Why does Excel turn (123) into a negative number?
Excel reads a number in brackets as a negative number when you type it. To keep the brackets as text, type an apostrophe first, like ‘(123), or format the cell as Text before typing.
Can I remove the brackets without changing the original cells?
Yes. Use the SUBSTITUTE formula in a new column. Once you’re happy with the result, copy the column and paste it as values if you no longer need the formula.
Why does Find and Replace say it can’t find anything?
The brackets are probably part of the number format (like negative numbers in brackets) and not in the values. Check the cell in the formula bar: if you don’t see the brackets there, change the number format instead.
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.