Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to remove all brackets from string in a range in Excel?
In the article, the user will learn how to remove or delete all of the brackets from the string that we have inserted in the cell such as a Word file and an Excel file in Microsoft Excel. Two examples are demonstrated in this article. First example, use the Find and Replace tab to eliminate all brackets from string in a certain range whereas second example use the Ku-tools tab to achieve the same goal. Both methods may be completed utilizing a straightforward way within Microsoft Excel by using the Remove Characters tab to remove the brackets.
Example 1: By Using Find and Replace Option
Step 1
Deliberate the Excel worksheet. Open the Microsoft Excel sheet and insert the data from the cells A1 to A6 as you need as shown below.
Step 2
In the Excel sheet, click on cell A1 and place the pointer in cell A1 and press the ctrl+F key to open the Find and Replace dialog box. In the dialog box, place the pointer and connect to the Replace tab then place the cursor in the Find What drop-box and type [ and click on the Replace All button. It will open the pop-up window then click on the ok button. In cell A1, the open bracket will be automatically removed as shown below.
In the Excel sheet, click on cell A1 and place the pointer in cell A1 and press the ctrl+F key to open the Find and Replace dialog box. In the dialog box, place the pointer and connect to the Replace tab then place the cursor in the Find What drop-box and type ] and click on the Replace All button. It will open the pop-up window then click on the OK button. In cell A1, the close bracket will be automatically removed as shown below.
Step 3
In the Excel sheet, select all the cells from A2 to A6, and press the ctrl+F key to open the Find and Replace dialog box. In the dialog box, place the pointer and connect to the Replace tab then place the cursor in the Find What drop-box and type [ and click on the Replace All button. It will open the pop-up window then click on the ok button. In all the cells, the open brackets for the other 5 cells will be automatically removed as shown below.
Step 4
In the Excel sheet, select all the cells from A2 to A6, and press the ctrl+F key to open the Find and Replace dialog box. In the dialog box, place the pointer and connect to the Replace tab then place the cursor in the Find What drop-box and type ] and click on the Replace All button. It will open the pop-up window then click on the ok button. In all the cells, the close brackets for the other 5 cells will be automatically removed as shown below.
Example 2: By Using Ku-tools
Step 1
In the Excel sheet, select all the cells and locate the pointer within the ribbon dataset. There are various tabs comprised within the top corner. Place the pointer within the Ku-tools tab and connect to the tab that has countless options encompassed. On the Ku-tools tab, place the pointer and connect to the Text tab which has the drop-down menu. In the menu, choose and link to the option Remove Characters tab in the Editing group that will open the dialog box as shown below.
Step 2
In the dialog box, place the pointer and click on the checkbox Custom that will be checked. Locate the pointer in the drop-box and type [] that will display all the data in the Preview pane then click on the ok button. In the sheet, the values will be automatically presented without brackets. This method will be removed the open and closed brackets in all the data in row A as shown below.
Conclusion
The users may use the easy instance to show how they can remove or delete the brackets in the present data that is included in row A. The users can use the Find and Replace tab to remove the brackets. We may use the Ku-tools tab to remove the characters with the Remove Characters tab which will remove all the brackets at the same time. We must practice the vital choices from the ribbon and update the data.
100 Views
