how to remove brackets in excel

Remove Brackets in Excel: Easy Steps

By John Moore
AD

Are you tired of seeing unwanted brackets in your Excel sheets? They can clutter your data and make it harder to read. Here's a step-by-step guide on how to remove brackets in Excel, tailored to help you enhance your data analysis and presentation.

Before we dive in, ensure you've chosen the correct data range and that the brackets aren't necessary parts of your data. Let's begin with the simple method for removing brackets from text strings.

Removing Brackets from Text Strings

This method works best when brackets are the only issue in your text strings. Here's how to do it:

AD
How To Remove Brackets & Anything Inside it In Excel
How To Remove Brackets & Anything Inside it In Excel
the easy way to remove blank rows in excel - quick tips on how to use them
the easy way to remove blank rows in excel - quick tips on how to use them
Add, Increase or Remove Indent in Excel
Add, Increase or Remove Indent in Excel

1. Select the cells containing the text strings with brackets. If they're not all together, use 'Shift + arrow keys' to select them.

Using Find and Replace

2. Press 'Ctrl + H' (Windows) or 'Cmd + H' (Mac) to open the 'Find and Replace' dialog box.

How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy
How to Remove Quick Access Toolbar in Excel (4 Easy Ways) - ExcelDemy
an excel spreadsheet showing the number of items in each column
an excel spreadsheet showing the number of items in each column

3. In the 'Find what' field, type the bracket (ensure it's the same as in your data) and leave the 'Replace with' field empty. Click 'Replace All'.

Using Flash Fill

4. In newer Excel versions, you can use the Flash Fill feature for better accuracy. Click in a cell next to your data, type the word without brackets, then click 'Flash Fill' in the 'Home' tab.

AD

5. Excel will predictively fill in the rest of the column. If it's correct, press 'Enter' to apply the changes.

Removing Brackets from Numbers

If your brackets are causing calculation issues, you'll need to remove them along with any leading/trailing spaces. Here's how:

1. Select your data and go to the 'Home' tab, then 'Number'.

AD

Using Text to Columns

2. Click 'Text to Columns', choose 'Delimited', then click 'Next'. Select 'Space' (or the delimiter) and click 'Next' again, then 'Finish'.

3. You'll now see your numbers with leading/trailing spaces. To remove these, click in the formula bar, and for a single cell, type '=TRIM(' & cell reference & ')'. Press 'Enter', then drag the fill handle to copy this formula for all cells.

Using Find and Replace

4. Again use 'Ctrl + H'. In the 'Find what' field, type the bracket and any leading/trailing spaces, leaving the 'Replace with' field empty. Click 'Replace All'.

AD

And there you have it! Whether your brackets were mere bothersome characters or disrupting calculations, now you know how to remove brackets in Excel like a pro. Happy data cleaning!

AD