Skip to main content

How to remove text within brackets/parentheses in Excel?

Author: Sun Last Modified: 2020-05-25

If you have multiple data, and some of the data is within brackets or parentheses, now you want to remove the text within the brackets as below screenshots shown, how can you quickly to solve it?

doc remove within bracket 1

Remove text in parentheses with Find and Replace function

Remove text in parentheses across multiple sheets with Kutools for Excelgood idea3

Remove parentheses with Kutools for Excelgood idea3

To remove text which is around with brackets, you can find them out, and then replace them as blank.

1. Press Ctrl + H keys to enable the Find and Replace dialog, in the Find what textbox, type (*) into it, and go to Replace with textbox, type ( ) into it. See screenshot:

doc remove within bracket 2

2. Then click Replace All. Then a dialog pops out to remind you the number of replacements. Click OK to close it.

doc remove within bracket 3

If you have opened multiple workbooks, and need to remove all the text within parentheses in the opened workbooks, you can use Kutools for Excel’s advanced Find and Replace to find and replace text across workbooks.

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

After free installing Kutools for Excel, please do as below:

1. Click Kutools > Navigation to enable Navigation pane, then click Find and Replace icon to go to Find and Replace section. See screenshots:

doc remove within bracket 4

3. Then select Replace tab, and in the Find what textbox, type (*) into it, and go to Replace with textbox, type ( ) into it, and select All workbooks under Within drop down list, See screenshot:

Tip: If you want to replace in specific sheets, you can check the sheet names in Workbooks list.

doc remove within bracket 5

4. Click Replace All. Then all the texts within brackets are replaced with blank.

With Navigation pane, you can list all open worksheets’ names, range names, and add auto text as you like. Click here to know more about Navigation.

If you want to remove parentheses or brackets, you can use Kutools for Excel’s Remove Characters.

After free installing Kutools for Excel, please do as below:

1. Select the data range you want to remove brackets, and click Kutools > Text > Remove Characters. See screenshot:

doc remove within brakect 9

2. In the Remove Characters dialog, only check Custom option, and then type () into the textbox, you can preview the result in the Preview pane. See screenshot:

doc remove within bracket 7

3. Click Ok or Apply. Now all the brackets of selection are removed.

doc remove within bracket 8

Click here to know more about Remove Characters.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations