You can use the following formula to remove parentheses from the text in a specific cell in Excel:
=SUBSTITUTE(SUBSTITUTE(A2,"(", ""), ")", "")
This particular formula removes all parentheses from the text in cell A2.
The following example shows how to use this formula in practice.
Example: How to Remove Parentheses in Excel
Suppose we have the following dataset in Excel that contains information about various basketball players:
Suppose we would like to remove all parentheses from each cell in the Position column.
We can type the following formula into cell C2 to do so:
=SUBSTITUTE(SUBSTITUTE(A2,"(", ""), ")", "")
We can then click and drag this formula down to each remaining cell in column C:
Notice that column C now displays the text in each corresponding cell in column A with the parentheses removed.
How This Formula Works
Recall the formula that we used to remove parentheses from the text in cell A2:
=SUBSTITUTE(SUBSTITUTE(A2,"(", ""), ")", "")
Here is how this formula works:
The SUBSTITUTE function in Excel substitutes all occurrences of a specific pattern with another pattern.
The inner SUBSTITUTE function in the formula substitutes all left parentheses ( with a blank.
Then, the outer SUBSTITUTE function substitutes all right parentheses ) with a blank.
The end result is that all parentheses in cell A2 are replaced with blanks, which is equivalent to removing all parentheses altogether.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Check if Cell Contains Partial Text
Excel: How to Check if Cell Contains Text from List
Excel: How to Count Frequency of Text
