How to Remove Parentheses from Phone Numbers in Excel (5 Methods)

This article provides some basic ideas on how to remove parentheses from phone numbers in Excel. Suppose you want to save some phone numbers of some people without any parentheses in them.

I explained 5 methods so that you can remove the parentheses from mobile numbers in the simplest possible way. In the dataset, we have some guys and their corresponding phone numbers.

Download Practice Workbook

5 Ways to Remove Parentheses from Phone Numbers in Excel

1. Removing Parentheses from Phone Numbers by Using Nested SUBSTITUTE Function

The easiest possible way to remove parentheses from phone numbers is to use the nested SUBSTITUTE function. Let’s discuss the process below.

Steps:

• Make a new column for mobile numbers without parentheses and type the following formula in cell D5.

Here, the SUBSTITUTE function removes the parentheses in two steps. The nested SUBSTITUTE function removes the first parentheses and the other removes the second parentheses.

• Now hit the ENTER button and you will see the phone number in cell C5 becomes parentheses

• Use the Fill Handle to AutoFill the lower cells and you will see all the phone numbers are removed from parentheses.

By following this simple formula, you can easily remove parentheses from phone numbers.

2. Using Excel MID and RIGHT Functions to Remove Parentheses from Phone Numbers

Another easy way to remove parentheses from mobile numbers is using the MID and RIGHT function. Let’s hop into the procedure.

Steps:

• First, make a new column for the parentheses-free mobile numbers and type the following formula in cell D5.

In this formula, the MID function returns the characters from 2nd to 4th position of the mobile number in cell C5 and the RIGHT function returns 9 characters from the right side of the mobile number as mobile numbers follow a pattern. The ampersand (&) helps these two strings of characters to get together.

• Now press ENTER and you will see the mobile number in cell C5 is removed from the parentheses.

• Use the Fill Handle to AutoFill the lower cells and you will see all the mobile numbers become parentheses

This is another simple method to remove parentheses from mobile numbers.

Read More: [Solved!]: Excel Phone Number Format Not Working (4 Solutions)

3. Applying Combined Functions to Remove Parentheses from Phone Numbers

We can also remove parentheses from cell phone numbers by combining the MID and RIGHT functions into the SUBSTITUTE function. I’m explaining in the following description.

Steps:

• Make a new column for the parentheses-free mobile numbers and type the following formula in cell D5.

Finally we got the phone number 212 222-3246.

• Hit ENTER and you will see no parentheses in the phone number.

• Now use the Fill Handle to AutoFill the lower cells and you will see all the phone numbers are now parentheses-free.

By following this approach, you can terminate parentheses from phone numbers in Excel.

Similar Readings

• How to Write Phone Number in Excel (Every Possible Way)
• How to Format Phone Number with Dashes in Excel (2 Ways)
• How to Format Phone Number with Country Code in Excel (5 Methods)

4. Utilizing Combined Functions into the REPLACE Function to Remove Parentheses from Phone Numbers

Removing parentheses from phone numbers can also be done by combining the LEFT, RIGHT, and FIND functions into the REPLACE function. This is going to be a little bit messy. Let’s just cut to the chase.

Steps:

• Make a new column for the parentheses-free phone numbers and type the following formula in cell D5.

Finally, we get the mobile number free from parentheses.

• Press the ENTER key to see the output in cell D5.

• Use the Fill Handle to AutoFill the lower cells.

Thus you can remove parentheses from the phone numbers you want.

Read More: Excel Formula to Change Phone Number Format (5 Examples)

5. Using Replace Command from Find & Select Feature

If you don’t feel comfortable using the formula, you can remove parentheses using Replace command from the Find & Select ribbon. Let’s follow my process below.

Steps:

• Select the range C5:C11, then go to Home >> Find & Select >> Replace

• A dialog box will appear. Type first parentheses “(“ in Find what
• As we want to remove the parentheses, we kept empty the Replace with
• Then click on Replace All.

• A message box will appear. Just click OK and Close the dialog box.

You will see all the first parentheses gone from the phone numbers.

• To remove the second parentheses, open the Replace command again and type 2nd parentheses “)” in Find what section.
• Keep the “Replace with” section empty.
• Click on Replace All and also click on OK in the message box.
• After that, Close the window.

You will now see all the phone numbers without any parentheses.

This is a very easy method to remove parentheses from phone numbers.

Practice Section

The following image is the dataset that we have worked on to explain the methods to remove parentheses from phone numbers. You can practice these methods on your own.

Conclusion

The article emphasizes on 5 easy methods of how to remove parentheses from phone numbers in Excel. By following these methods, you can remove parentheses not only from phone numbers but also from any other strings or texts. I hope this article will be useful for you to solve similar kinds of problems. If you have any easier methods or ideas or feedback, please leave them in the comment box. This will help me enrich my upcoming articles.

Related Articles

• How to Format Phone Number with Extension in Excel (3 Easy Ways)
• How to Add Dashes to SSN in Excel (6 Methods)
• Format TextBox for Phone Number with Excel VBA (A Step-by-Step Guide)