While dealing with data in MS Excel, there may be unnecessary parentheses within it. No doubt, we would like to learn some easy and fast techniques with which we can remove extra brackets. In this article, you will learn 4 easy methods to remove parentheses in excel with suitable examples and proper illustrations.

**Table of Contents**hide

**Download Practice Book**

You can download the free Excel template from here and practice on your own.

**4 Easy Ways to Remove Parentheses in Excel**

**Method 1: Use Find & Replace Command to Remove Parentheses in Excel**

Let’s get introduced to our dataset first. I have placed some fruits and vegetables and their prices in my dataset. Look that there are numbers within parentheses with every item. The numbers denote the product codes where the parentheses are just redundancies.

Now we’ll remove the parentheses using the **Find & Replace** command.

At first, we’ll remove the start parenthesis “**(**“.

**Step 1:**

**➥** Select the data range.

**➥** Press **Ctrl+H** on your keyboard then the **Find & Replace** dialog box will open up.

**➥** Type “**(**“ in the **Find what** bar and keep the **Replace with** bar empty.

**➥** Later, press **Replace All**.

The first parentheses are removed successfully.

Now we’ll remove the end parentheses “**)**”.

**Step 2:**

**➥** Again type “**)**“ in the **Find what** bar and keep the **Replace with** bar empty.

**➥** Then press **Replace All **again**.**

Now you will see that all the parentheses are removed perfectly.

**Read More:** **How to Remove Dollar Sign in Excel (7 Easy Ways)**

**Method 2: Insert SUBSTITUTE Function to Delete Parentheses in Excel**

In this method, we’ll use **the SUBSTITUTE function** to remove parentheses in excel. The **SUBSTITUTE **function finds a text in a cell and replaces it with another text.

We’ll do the operation with two easy steps.

First, we’ll remove the start parentheses in **Column Output1**. And then end parentheses in **Column Output2**. Let’s see 👇

**Step 1:**

**➥** Activate **Cell D5**.

**➥** Type the formula given below:

`=SUBSTITUTE(B5,"(","")`

**➥** Then just hit the **Enter**.**➥** Drag the** Fill Handle** icon to copy the formula for the cells below.

Soon after, you will spot that the start parentheses are gone.

Now we’ll remove the end parentheses.

**Step 2:**

**➥** In **Cell E5** write the formula-

`=SUBSTITUTE(D5,")","")`

**➥** Press the **Enter **button to get the result now.

**➥** Then drag the **Fill Handle** icon to copy the formula.

Now we see that all the parentheses are no more.

**Read More: How to Remove Spaces in Excel: With Formula, VBA & Power Query**

**Similar Readings:**

**How to Remove Blank Characters in Excel (5 Methods)****How to Remove Non-Printable Characters in Excel (4 Easy Ways)****VBA to Remove Characters from String in Excel (7 Methods)****Remove the Last 3 Characters in Excel (4 Formulas)****How to Remove Non-numeric Characters from Cells in Excel**

**Method 3: Combine LEFT And FIND Functions to Erase Parentheses with Text in Excel**

Here, we’ll combine two functions to remove parentheses in excel. They are **the LEFT function** and **the FIND function**. The **LEFT **function returns the first character or characters in a text string from the left based on the number of characters you specify. The **FIND **function is used to find the position of a substring in a string.

Now, let’s see the steps one by one.

**Step 1:**

**➥** Write the given formula in **Cell D5**:

`=LEFT(B5,FIND("(",B5,1)-1)`

**➥** Now click the **Enter **button to get the output.

**Step 2:**

**➥** Finally, just drag the **Fill Handle** icon to copy the formula.

**👇**** Formula Breakdown:**

**➥**** FIND(“(“,B5,1)**

The **FIND **function will find the position number of start parentheses starting from first position that returns-

**{7}**

**➥**** LEFT(B5,FIND(“(“,B5,1)-1)**

Then the **LEFT **function will keep only 6 letters starting from the left, that’s why 1 is subtracted from the output of the **FIND **function. Finally, it will return as-

**{Carrot}**

**Read More:** **How to Remove Characters from Left in Excel (6 Ways)**

**Method 4: Embed VBA Macros to Remove Parentheses in Excel**

If you like to work with codes in Excel, then you can do it with the **Visual basic Application** or,** VBA**. Here, we’ll remove all the parentheses using **VBA **codes.

**Step 1:**

**➥** Right-click on the sheet title.

**➥** Then select **View Code** from the **context menu**.

A **VBA **window will open up.

**Step 2:**

**➥** Write the codes given below-

```
Option Explicit
Sub DelParentheses()
Cells.Select
Selection.Replace What:="(", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:=")", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
```

**➥** Then just press the **Run icon** to run the codes.

A **Macro** dialog box will open up.

**Step 3:**

**➥** Press **Run**.

Now take a look that all the parentheses are deleted.

**Related Content:** **How to Remove the First Character from a String in Excel with VBA**

**Conclusion**

I hope all of the methods described above will be good enough to remove parentheses in excel. Feel free to ask any questions in the comment section and please give me your feedback. Visit our website **Exceldemy.com** to explore more.