Remove parentheses and the content inside quickly

Uploaded time: January 24, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

Remove parentheses and the content inside quickly

Remove parentheses and the content inside quickly

When processing a table, we may find that some information contains parentheses, but it'd be troublesome to delete them one by one.

Today, we're going to learn theskill to delete these parentheses and the content inside quickly.

Take this table as an example. There are parentheses following the actors' names, and we want to delete these parentheses and the nationality inside.

1. Select the cell range which contains the parentheses and pressCtrl+H to pop up the Replace dialog.

2. In the Find what text box, input (*).

Here we need a brief explanation. The symbol * is a wildcard, which serves as a special statement for fuzzy search. It can represent multiple characters when we search for words.

Inputting (*) means we need to find all the characters that are marked with parentheses.

3. we don't need to input anything in the Replace with area. Then click Replace All to delete all the parentheses and the content inside.

Its principle is to use the Find and Replace function in WPS Spreadsheet to replace the specified content with a blank, which is equivalent to deleting the content.  

Similarly, you can also use this method to implement other replacements.

For example, to delete all the double quotes and the content inside in this table, we can input * in the Find what text box.And we leave the Replace with area blank and click Replace All.

What a practical feature! Did you get it?

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.