When importing data from another source into Excel, you often encounter some strange formatting, such as parentheses around data. This poses a problem, since manually editing the numerous data entries would take far too long. You need also be concerned that deleting all parentheses would render any formulas inoperative, since parentheses are a vital component of all functions. However, using Excel's Find and Replace function intelligently removes parentheses in values, while ignoring them in functions. This allows you to quickly remove data parentheses, while still keeping your formulas functional.
- Skill level:
Other People Are Reading
Open your spreadsheet in Microsoft Excel.
Hold the "Ctrl" key and press "H" to open the "Find and Replace" window.
Enter the opening parenthesis, "(", in the "Find what" field of the "Replace" tab and leave the "Replace with" field blank.
Click "Replace All" to remove all opening parenthesis, while ignoring those required for functions.
Repeat the procedure and enter the closing parenthesis, ")", in the "Find what" field.