trumpexcel.com Open in urlscan Pro
162.159.135.42 Public Scan

Back to summary

Submitted URL:
http://trumpexcel.com/remove-parentheses-excel/
Effective URL:
https://trumpexcel.com/remove-parentheses-excel/
Submission: On April 20 via manual (April 20th 2024, 4:05:24 am UTC) from US — Scanned from DE

Form analysis
6 forms found in the DOM

GET https://trumpexcel.com

<form class="elementor-search-form" action="https://trumpexcel.com" method="get">
  <div class="elementor-search-form__toggle" tabindex="0" role="button"> <i aria-hidden="true" class="fas fa-search"></i> <span class="elementor-screen-only">Search</span> </div>
  <div class="elementor-search-form__container"> <label class="elementor-screen-only" for="elementor-search-form-57f4116">Search</label> <input id="elementor-search-form-57f4116" placeholder="Search..." class="elementor-search-form__input"
      type="search" name="s" value="">
    <div class="dialog-lightbox-close-button dialog-close-button" role="button" tabindex="0"> <i aria-hidden="true" class="eicon-close"></i> <span class="elementor-screen-only">Close this search box.</span> </div>
  </div>
</form>

Name: New Form — POST

<form class="elementor-form" method="post" name="New Form"> <input type="hidden" name="post_id" value="31651"> <input type="hidden" name="form_id" value="02fa695"> <input type="hidden" name="referer_title"
    value="Remove Parentheses (Brackets) in Excel [4 Easy Ways]"> <input type="hidden" name="queried_id" value="39824">
  <div class="elementor-form-fields-wrapper elementor-labels-">
    <div class="elementor-field-type-text elementor-field-group elementor-column elementor-field-group-first_name elementor-col-100"> <label for="form-field-first_name" class="elementor-field-label elementor-screen-only"> Name </label> <input
        size="1" type="text" name="form_fields[first_name]" id="form-field-first_name" class="elementor-field elementor-size-md  elementor-field-textual" placeholder="Name"> </div>
    <div class="elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required"> <label for="form-field-email" class="elementor-field-label elementor-screen-only"> Email
      </label> <input size="1" type="email" name="form_fields[email]" id="form-field-email" class="elementor-field elementor-size-md  elementor-field-textual" placeholder="Email" required="required" aria-required="true"> </div>
    <div class="elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons"> <button type="submit" class="elementor-button elementor-size-md"> <span> <span class=" elementor-button-icon"> </span> <span
            class="elementor-button-text">YES - SEND ME THE EBOOK</span> </span> </button> </div>
  </div>
</form>

POST https://trumpexcel.com/wp-comments-post.php

<form action="https://trumpexcel.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
  <p class="comment-form-comment"><label for="comment" class="screen-reader-text">Comment</label><textarea autocomplete="new-password" id="d22348054a" name="d22348054a" cols="45" rows="8" required=""></textarea><textarea id="comment"
      aria-label="hp-comment" aria-hidden="true" name="comment" autocomplete="new-password"
      style="padding:0 !important;clip:rect(1px,1px,1px,1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;" tabindex="-1"></textarea><template
      data-nitro-marker-id="95880389e5dbcf532148fc1bb4481de9-1"></template></p><label for="author" class="screen-reader-text">Name</label><input placeholder="Name *" id="author" name="author" type="text" value="" size="30" required=""> <label
    for="email" class="screen-reader-text">Email</label><input placeholder="Email *" id="email" name="email" type="email" value="" size="30" required=""> <label for="url" class="screen-reader-text">Website</label><input placeholder="Website" id="url"
    name="url" type="url" value="" size="30">
  <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="39824" id="comment_post_ID"> <input type="hidden" name="comment_parent"
      id="comment_parent" value="0"> </p>
</form>

Name: New Form — POST

<form class="elementor-form" method="post" id="Below_Title" name="New Form"> <input type="hidden" name="post_id" value="42813"> <input type="hidden" name="form_id" value="2842939d"> <input type="hidden" name="referer_title"
    value="Remove Parentheses (Brackets) in Excel [4 Easy Ways]"> <input type="hidden" name="queried_id" value="39824">
  <div class="elementor-form-fields-wrapper elementor-labels-">
    <div class="elementor-field-type-text elementor-field-group elementor-column elementor-field-group-first_name elementor-col-100"> <label for="form-field-first_name" class="elementor-field-label elementor-screen-only"> Name </label> <input
        size="1" type="text" name="form_fields[first_name]" id="form-field-first_name" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Your Name"> </div>
    <div class="elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required"> <label for="form-field-email" class="elementor-field-label elementor-screen-only"> Email
      </label> <input size="1" type="email" name="form_fields[email]" id="form-field-email" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Email to Get the Ebook" required="required" aria-required="true"> </div>
    <div class="elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons"> <button type="submit" class="elementor-button elementor-size-sm"> <span> <span class=" elementor-button-icon"> </span> <span
            class="elementor-button-text">SEND ME THE EBOOK</span> </span> </button> </div>
  </div>
</form>

Name: New Form — POST

<form class="elementor-form" method="post" id="Homepage" name="New Form"> <input type="hidden" name="post_id" value="42805"> <input type="hidden" name="form_id" value="7286607"> <input type="hidden" name="referer_title"
    value="Remove Parentheses (Brackets) in Excel [4 Easy Ways]"> <input type="hidden" name="queried_id" value="39824">
  <div class="elementor-form-fields-wrapper elementor-labels-">
    <div class="elementor-field-type-text elementor-field-group elementor-column elementor-field-group-first_name elementor-col-100"> <label for="form-field-first_name" class="elementor-field-label elementor-screen-only"> Name </label> <input
        size="1" type="text" name="form_fields[first_name]" id="form-field-first_name" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Your Name"> </div>
    <div class="elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required"> <label for="form-field-email" class="elementor-field-label elementor-screen-only"> Email
      </label> <input size="1" type="email" name="form_fields[email]" id="form-field-email" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Email to Get the Ebook" required="required" aria-required="true"> </div>
    <div class="elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons"> <button type="submit" class="elementor-button elementor-size-sm"> <span> <span class=" elementor-button-icon"> </span> <span
            class="elementor-button-text">SEND ME THE EBOOK</span> </span> </button> </div>
  </div>
</form>

Name: New Form — POST

<form class="elementor-form" method="post" id="Free_Ebook_Page" name="New Form"> <input type="hidden" name="post_id" value="32614"> <input type="hidden" name="form_id" value="1ae6c2f"> <input type="hidden" name="referer_title"
    value="Remove Parentheses (Brackets) in Excel [4 Easy Ways]"> <input type="hidden" name="queried_id" value="39824">
  <div class="elementor-form-fields-wrapper elementor-labels-">
    <div class="elementor-field-type-text elementor-field-group elementor-column elementor-field-group-first_name elementor-col-100"> <label for="form-field-first_name" class="elementor-field-label elementor-screen-only"> Name </label> <input
        size="1" type="text" name="form_fields[first_name]" id="form-field-first_name" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Your Name"> </div>
    <div class="elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required"> <label for="form-field-email" class="elementor-field-label elementor-screen-only"> Email
      </label> <input size="1" type="email" name="form_fields[email]" id="form-field-email" class="elementor-field elementor-size-sm  elementor-field-textual" placeholder="Email to Get the Ebook" required="required" aria-required="true"> </div>
    <div class="elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons"> <button type="submit" class="elementor-button elementor-size-sm"> <span> <span class=" elementor-button-icon"> </span> <span
            class="elementor-button-text">SEND ME THE EBOOK</span> </span> </button> </div>
  </div>
</form>

Text Content

Skip to content
 * About
 * Excel Functions
 * Blog
   * Excel Tips
   * VBA Tips
   * Charting
   * Pivot Table Tips
   * Excel Dashboard Tips
 * FREE Training
   * Excel Basic to Advanced
   * Excel Dashboard Course
   * Excel VBA Course
   * Excel Power Query Course
 * FREE Excel Templates

Menu
 * About
 * Excel Functions
 * Blog
   * Excel Tips
   * VBA Tips
   * Charting
   * Pivot Table Tips
   * Excel Dashboard Tips
 * FREE Training
   * Excel Basic to Advanced
   * Excel Dashboard Course
   * Excel VBA Course
   * Excel Power Query Course
 * FREE Excel Templates

Search
Search
Close this search box.

Home » Remove Parentheses in Excel




REMOVE PARENTHESES IN EXCEL

 * Sumit Bansal

FREE EXCEL TIPS EBOOK - Click here to get your copy

Most of my time working in Excel is spent cleaning data that I get from
different sources.

One common task that I have to do quite often is to remove parentheses (or
brackets) from the cells in a dataset.

In this video, I covered 10 less-known but amazing Excel tricks that can save
you a lot of time. These are simple Excel tricks that you can use in your
day-to-day work and be more efficient


 

As with almost everything else in Excel, there are multiple ways you can remove
the parenthesis from cells.



In this tutorial, I’m going to show you four such methods that you can use
depending on the structure of your data set or your personal preference. Each
method has its pros and cons, and I would list them so that you can decide which
method is best suited for you.

Note: In this article, I am showing you how to remove parentheses (), but you
can use the same methods to remove brackets [] as well.

This Tutorial Covers:

Toggle
 * Using Flash Fill to Remove Parentheses
 * Find and Replace to Remove Parentheses
 * Formulas to Remove Parentheses
 * VBA to Remove Parentheses


USING FLASH FILL TO REMOVE PARENTHESES

Flash Fill is a great tool that I often use while doing basic data clean-ups in
Excel (such as removing parentheses or brackets from cells).

To use Flash Fill, you first need to manually enter the result for one of the
cells in the adjacent cell.



When you enter the result for one of the cells in the adjacent cell and then use
Flash Fill, it will identify the pattern (using the result that you have
specified manually), and apply the same for the entire column.

Let me show you how it works with an example.

Below is a data set where I have the names followed by the state name. The state
name is in the parentheses that I want to remove.



Here are the steps to do this:

 1. In cell B2, which is in the column adjacent to our data set, enter the
    expected result – Richard Hanson, Texas



 2. Select cell B3
 3. Hold the Control key and press the E key (this is the keyboard shortcut to
    run Flash Fill)



As soon as you run Flash Fill, you will notice that the entire column gets
filled, and the parentheses/brackets have been removed from the text.




You can also run Flash Fill by going to the Home tab, then clicking on the Fill
icon (in the Editing group), and then clicking on the Flash Fill icon.

Note: Since Flash Fill works by identifying the pattern in the result you have
provided, there is a possibility that it may identify an incorrect pattern and
give you the wrong result. If that happens, try again by giving it two or three
examples of the result you want and then running the Flash Fill.

Below are the pros and cons of this method to remove parentheses:

PROsCONsQuick and EasyFlash Fill can identify the wrong pattern, so you need to
double-check the results.You need to manually enter the result in one or two
cells before using Flash FillThe results you get are static values, so if your
original data changes, you need to repeat the steps again.

Also read: Show Negative Numbers in Parentheses in Excel


FIND AND REPLACE TO REMOVE PARENTHESES

Find and Replace is another easy way to find and remove all the parentheses in
your data set.



Since the parentheses include an opening bracket and a closing bracket, you need
to use Find & Replace twice (to remove the two brackets separately).

Below is an example data set where I have the names followed by the US state
name in parentheses, and I want to remove the parentheses only.



Here are the steps to do this:

 1. Select the data set from which you want to remove the parentheses
 2. Click the Home tab



 3. Click on the Find & Select icon in the Editing group



 4. Click on the Replace option. This will open the Find and Replace dialog box.



 5. Enter ( in the Find what field.


 6. Click on Replace All. This will replace all the instances of ( in the
    dataset.


 7. Now, enter ) in the ‘Find what’ field.



 8. Click on Replace All. This will replace all the instances of ) in the
    dataset.



And done!



While this method may not be as quick as using Flash Fill, if you’re comfortable
using Find and Replace, it’s fast enough.

Pro Tip: Use the keyboard shortcut Control + H to open the Find and Replace
dialog box. To use this, hold the Control key and then press the H key.

Now let’s look at the pros and cons of this method for removing parentheses in
Excel.

PROsCONsWorks as expected.No need to create an additional column. You can use
Find and Replace on your original data column itself.It removes all instances of
the opening and closing bracket characters. You can not choose which instance of
the brackets would be removed.

Also read: How to Add Parentheses Around Text in Excel


FORMULAS TO REMOVE PARENTHESES

If you want more control while removing the parentheses from your data set, you
can consider using the formula method.

This can be done using the SUBSTITUTE function, which would identify the
position of the opening and closing brackets and replace them with a null
string.



Below is a data set where I want to remove the parenthesis from the state names.



Here is the formula that will do this:

=SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")

Enter the above formula in cell B2 and then apply it to the entire column (you
can copy the cell that has the formula and paste it into other cells or use the
Fill Handle and drag it down).




The above formula uses two substitute functions.

The first SUBSTITUTE function finds the position of the opening parenthesis
character (“(“) in the cell and substitutes it with a null string.

The result of the first SUBSTITUTE function is then used by the second
SUBSTITUTE function to find the closing parenthesis character (“)”) and replace
it with a null string.

If you do not need the original data, you can convert the formula values in
column B into static values and then remove the original data.

Now let’s look at the pros and cons of using the formula method for removing
parentheses/brackets in Excel.

PROsCONsIf your original data changes, the resulting output would automatically
updateYou get the result in a separate columnYou need to know the syntax of the
SUBSTITUTE function to be able to use it.


VBA TO REMOVE PARENTHESES

And the final way to remove parentheses in Excel is by using a simple VBA
formula.



Since this method requires a little bit of setup, it is more suited for people
who need to do this regularly.

So you can set up the VBA code once and then run it with a simple keyboard
shortcut or a click of a button to remove parentheses from the selected data
set.

Let me show you how this method works.

Below I have the same data set where I have the names in column A along with the
state names in parentheses, and I want to remove these parentheses.



Here are the steps to do this:


 1. Select the data set.
 2. Hold the ALT key and press the F11 key to open the Visual Basic editor.
    Alternatively, you can go to the Developer tab and then click on the Visual
    Basic icon.
 3. In the VB Editor, click on the Insert option in the menu and then click on
    the Module option. This will insert a new module for the workbook.


 4. Copy and paste the below VBA code into the module code window.

'Code developed by Sumit Bansal from https://trumpexcel.com
Sub RemoveParentheses()
    Dim rng As Range
    Dim cell As Range

    ' Set the current selection as the range to be used
    Set rng = Selection

    ' Loop through each cell in the selection
    For Each cell In rng
        ' Remove parentheses
        cell.Value = Replace(cell.Value, "(", "")
        cell.Value = Replace(cell.Value, ")", "")
    Next cell
End Sub



 5. To run this macro code, place the cursor anywhere within the code, and then
    press the F5 Key (or click on the run macro icon in the toolbar)



As soon as you run the above VBA code, it will go through each cell in the
selection, and then replace the opening bracket and closing bracket characters
with a null string.



Once you have this macro in your workbook, you can reuse it multiple times in
that workbook. You can also assign a keyboard shortcut to the macro so you can
run easily without opening the VB Editor.

To assign a keyboard shortcut to a macro, follow the below steps:

 1. Click on the Developer tab in the ribbon
 2. Click on the Macros option


 3. Select the macro name for which you want to assign a keyboard shortcut
 4. Click on the Options button



 5. Specify the shortcut



While this is not the fastest way to remove parentheses from Excel, once you
have the code in place, you can reuse it multiple times in the workbook that has
the code.

If you want to use this code in any workbook on your system, you can put it in
the Personal Macro Workbook. A VBA code stored in the Personal macro workbook
can be used on any Excel workbook on your system.

Caution: Changes done by a VBA macro code cannot be undone. So before you run
the code, make sure you have a backup copy of the data.

Now let’s look at the pros and cons of using VBA to remove parentheses/brackets
in Excel.



PROsCONsOnce you have the macro code in place, you can reuse it multiple
timesTakes more time to set up the VBA code in the back endYou can assign a
keyboard shortcut to the macro or add the macro icon to the Quick Access
ToolbarThe changes done by the VBA code are irreversible.

So these are four methods you can use to get rid of the parentheses from your
cells in Excel.

If you want to do this quickly once or twice, you can use the Flash Fill method
or the Find & Replace method. And if you need to do this on a regular basis, you
can consider using the VBA method.

I hope you found this article useful.

Other Excel articles you may also like:

 * How to Remove Cell Formatting in Excel (from All, Blank, Specific Cells)
 * How to Filter Cells with Bold Font Formatting in Excel
 * How to Remove Dashes (-) in Excel?
 * How to Remove Dotted Lines in Excel



FREE EXCEL BOOK


GET 51 EXCEL TIPS EBOOK TO SKYROCKET YOUR PRODUCTIVITY AND GET WORK DONE FASTER

Name
Email
YES - SEND ME THE EBOOK

Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I
started this website in 2013 with a simple goal: to share my love for Excel
through easy to follow tips, tutorials and videos. I'm here to help you get the
best out of MS Excel to save time and boost your productivity.


1 THOUGHT ON “REMOVE PARENTHESES IN EXCEL”

 1. rich saunders
    September 2023 at 11:47 pm
    
    How does some subscribe to your seminars? Have a few friends that want to
    join but we can’t find a link to subscribe Are you excepting any? Actually
    it has been awhile since I received one of you seminar emails
    
    Thoughts?
    Rich
    
    
    Reply


LEAVE A COMMENT CANCEL REPLY

Comment

Name Email Website



BEST EXCEL TUTORIALS



Best Excel Shortcuts



Conditional Formatting



Excel Skills



Creating a Pivot Table



Excel Tables



INDEX- MATCH Combo



Creating a Drop Down List



Recording a Macro



VBA Loops







©TrumpExcel.com – Free Online Excel Training



Privacy Policy | Sitemap

Twitter | Facebook | YouTube | Pinterest | Linkedin

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Name
Email
SEND ME THE EBOOK

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Name
Email
SEND ME THE EBOOK

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Name
Email
SEND ME THE EBOOK



Update Privacy Preferences
A Raptive Partner Site

trumpexcel.com Open in urlscan Pro 162.159.135.42 Public Scan

Form analysis 6 forms found in the DOM

GET https://trumpexcel.com

Name: New Form — POST

POST https://trumpexcel.com/wp-comments-post.php

Name: New Form — POST

Name: New Form — POST

Name: New Form — POST

Text Content

trumpexcel.com Open in urlscan Pro
162.159.135.42 Public Scan

Form analysis
6 forms found in the DOM