How to Remove parentheses in Excel

Removing Parentheses in Excel Using Formulas

To remove parentheses in Excel using a formula, you can use the SUBSTITUTE function. Here’s an example:

  1. Select the cell or column where you want to remove the parentheses.
  2. In an empty cell, type the following formula: =SUBSTITUTE(A1,”(“,””)
  3. Replace “A1” with the cell reference of the cell that contains the text you want to modify.
  4. Press Enter.
  5. Copy the formula down the column, if necessary.

This formula will replace all open parentheses with an empty string (“”), effectively removing them from the original text.

You can modify the formula to remove closed parentheses as well by adding another SUBSTITUTE function like this:

=SUBSTITUTE(SUBSTITUTE(A1,”(“, “”),”(“,””)

This formula will remove both open and close parentheses from the original text.

Removing Parentheses in Excel Using Find and Replace

Another way to remove parentheses in Excel is by using the Find and Replace tool. Here’s how:

  1. Select the cell or column where you want to remove the parentheses.
  2. Press Ctrl+H to open the Find and Replace dialog box.
  3. In the “Find what” field, type “(” (without the quotes).
  4. Leave the “Replace with” field blank.
  5. Click “Replace All”.
  6. Repeat steps 3-5 for the “)” character to remove closed parentheses as well.

This method will replace all occurrences of the parentheses characters with an empty string (“”), effectively removing them from the original text.

Removing Parentheses and Their Contents in Excel Using Formulas

If you want to remove both the parentheses and their contents in Excel, you can use the following formula:

=LEFT(A1,FIND(“(“,A1)-1)&RIGHT(A1,LEN(A1)-FIND(“)”,A1))

This formula will remove both the open and close parentheses and their contents from the original text. To use this formula, replace “A1” with the cell reference of the cell that contains the text you want to modify.

Removing Parentheses in Excel

There are several ways to remove parentheses from an Excel sheet. Here are a few methods:

  1. Using Find and Replace
  2. Using Excel’s CLEAN function
  3. Using Excel’s SUBSTITUTE function

Removing Brackets and Parentheses in Excel

Excel’s Find and Replace function can be used to remove brackets and parentheses from a sheet. Here’s how:

  1. Press Ctrl + H to open the Find and Replace dialog box.
  2. In the “Find what” field, type “[” or “(” (without quotes) to remove brackets or parentheses, respectively.
  3. Leave the “Replace with” field empty.
  4. Click on the “Replace All” button.

This will remove all occurrences of both left and right brackets and parentheses in the sheet.

Deleting Parentheses Around Text in Excel

You can use Excel’s SUBSTITUTE function or Text to Columns feature to delete parentheses around text in Excel. Here’s how:

  1. Using Excel’s SUBSTITUTE Function:
  • In an empty cell, type =SUBSTITUTE(cell reference,”(“,””) to remove left parentheses or =SUBSTITUTE(cell reference,”)”,””) to remove right parentheses.
  • Replace “cell reference” with the cell that contains the text you want to remove parentheses from.
  • Press Enter to apply the formula.
  • Copy and paste the formula to other cells as needed.
  1. Using Excel’s Text to Columns Feature:
  • Select the range of cells that contain the text you want to modify.
  • Go to the Data tab in the ribbon and click on Text to Columns.
  • Choose Delimited and click Next.
  • Uncheck all delimiters and check Other.
  • Enter the left parenthesis into the Other field and click Finish.
  • Repeat the above steps, but enter the right parenthesis into the Other field instead of the left parenthesis.

This method will separate the text within the parentheses into separate columns and remove the parentheses.

Using a Macro to Remove All Parentheses in Excel

Yes, you can use a macro to remove all parentheses in an Excel sheet. Here’s an example of a macro that removes both open and close parentheses:

  1. Press Alt + F11 to open the Visual Basic Editor.
  2. In the Project Explorer window, double-click on the sheet you want to modify.
  3. Click on Insert > Module to add a new module to the workbook.
  4. Paste the following code into the module:
Copy CodeSub RemoveParentheses()
Dim cell As Range
For Each cell In Selection
cell.Value = Replace(cell.Value, "(", "")
cell.Value = Replace(cell.Value, ")", "")
Next cell
End Sub
  1. Close the Visual Basic Editor.
  2. Select the range of cells where you want to remove parentheses.
  3. Go to the Developer tab in the ribbon and click on Macros.
  4. Select the macro named RemoveParentheses and click Run.

This will remove all parentheses from the selected cells.

Removing Only the Opening or Closing Parentheses in Excel

To remove only the opening or closing parentheses in Excel, you can use the SUBSTITUTE function with a LEFT or RIGHT function, respectively. Here are examples:

  • To remove only the opening parentheses: =SUBSTITUTE(A1,”(“,””) This formula removes all occurrences of the “(” character in cell A1.
  • To remove only the closing parentheses: =LEFT(A1,FIND(“)”,A1)-1) This formula removes the closing “)” character from the end of cell A1.

Note that these formulas assume that there is only one opening or closing parenthesis in each cell. If there are multiple instances of the character in a cell, the formula may not work as expected.

Removing Nested Parentheses in Excel

To remove nested parentheses in Excel, you can use the SUBSTITUTE function in combination with a loop. Here’s an example:

  1. In an empty cell, type =A1 and press Enter. This will create a copy of the text in cell A1.
  2. In another empty cell, type =LEN(A2)-LEN(SUBSTITUTE(A2,”(“,””)) and press Enter. This will count the number of open parentheses in cell A2.
  3. Copy the formula in step 1 down the column to create copies of the text in all cells you want to modify.
  4. In another empty cell, type =MAX(B:B) and press Enter. This will return the maximum number of open parentheses in the range.
  5. Type the following formula in an empty cell: =A3 (replace “A3” with the first cell containing the copied text).
  6. In the same row, type the following formula in another cell: =SUBSTITUTE(C3,”(“,IF(ROW()-ROW($C3)+1<=3)+1<=D3,””,”(“))3,””,”(“))(replace”C3″ with the cell containing the copied text,and”D$3” with the cell containing the maximum number of open parentheses)
  7. Copy the formula in step 6 down the column to apply it to all cells you want to modify.

This will remove all nested parentheses from the original text. Note that this method may not work correctly if there are other instances of the “(” character within the text that are not part of the nested parentheses.

Leave a Reply

Your email address will not be published. Required fields are marked *