Remove parentheses and the content inside quickly

Uploaded time: January 24, 2022 Difficulty: Beginner

Remove parentheses and the content inside quickly

Remove parentheses and the content inside quickly

Tips: you can turn on the volume by clicking

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 the skill 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 press Ctrl+H to pop up the Replace dialog.

_1.gif

 

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.

_2.gif

 

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. 

_3.gif

 

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.