WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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

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. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.