Excel Formula to Remove Text Inside Parentheses

Manually scrubbing extraneous text inside parentheses from your spreadsheets is tedious and highly prone to human error. While standard funding sources and database exports provide invaluable raw intelligence, they often arrive cluttered with regional codes or footnotes in brackets. Streamlining this formatting grants you immediate, uncluttered clarity for professional reporting.

Using =TRIM(REPLACE(A1, FIND("(", A1), FIND(")", A1) - FIND("(", A1) + 1, "")) strips these elements seamlessly. A key stipulation to remember is that this specific formula targets the first pair of parentheses; nested or multiple sets require a recursive approach.

Below, we will explore the exact formula mechanics, step-by-step configurations, and alternative methods for handling complex strings.

When working with imported data, system exports, or user-generated lists in Microsoft Excel, you will often find text strings containing extra information enclosed in parentheses. Common examples include names with job titles (e.g., "John Doe (Manager)"), products with SKUs (e.g., "Wireless Mouse (MS-402)"), or cities with country codes (e.g., "Paris (FR)").

While this supplemental data is helpful in some contexts, it can ruin your data analysis, lookups (like VLOOKUP or XLOOKUP), and reporting. Cleaning this data manually is tedious and prone to errors. Fortunately, Excel offers several ways to strip out parenthetical text, ranging from simple non-formula hacks to complex, dynamic formulas. This comprehensive guide will walk you through the best methods to replace text inside parentheses-along with the parentheses themselves-with nothing.

Method 1: The Modern Office 365 Regex Way (Recommended)

If you are using Microsoft 365 or Excel for the Web, Excel now supports native regular expression functions. This is by far the cleanest, most robust, and most powerful way to strip parentheses and the text inside them.

The Formula

=TRIM(REGEXREPLACE(A2, "\s*\([^)]*\)", ""))

How It Works

• REGEXREPLACE(A2, ...): This function searches the cell A2 for a pattern match and replaces it with another string (in this case, an empty string "").
• \s*: Matches zero or more spaces leading up to the parenthesis. This prevents leaving double spaces or trailing spaces behind.
• \( and \): Because parentheses have special meanings in regular expressions, they are escaped with backslashes to match literal opening and closing parentheses.
• [^)]*: This matches any character that is not a closing parenthesis, repeated zero or more times. It ensures the formula safely grabs everything inside the brackets.
• TRIM(...): A final cleanup wrapper to remove any accidental leading, trailing, or double spaces.

Pros: Extremely concise; easily handles multiple sets of parentheses in a single cell; does not break if no parentheses are present.

Method 2: Classic Excel Formula (For Excel 2013, 2016, 2019, and 2021)

If you or your coworkers are on older versions of Excel that do not support regular expressions or new text functions, you must rely on a combination of classic text manipulation functions: REPLACE, SEARCH, LEN, and IFERROR.

The Formula

=IFERROR(TRIM(REPLACE(A2, SEARCH("(", A2), SEARCH(")", A2) - SEARCH("(", A2) + 1, "")), A2)

Step-by-Step Breakdown

To understand this nested formula, let's break it down from the inside out using the sample text: "Wireless Mouse (MS-402)" in cell A2.

1. Find the starting point: SEARCH("(", A2) looks for the opening parenthesis. In our example, it finds it at character position 16.
2. Find the ending point: SEARCH(")", A2) looks for the closing parenthesis, finding it at position 24.
3. Calculate the length of the text to remove: SEARCH(")", A2) - SEARCH("(", A2) + 1 subtracts 16 from 24 and adds 1, which equals 9. This is the exact number of characters from ( to ).
4. Replace the text: REPLACE(A2, 16, 9, "") tells Excel to go to cell A2, start at character position 16, count 9 characters forward, and replace that chunk with nothing (""). This results in "Wireless Mouse ".
5. Trim extra space: TRIM(...) cuts off the lingering space at the end of the text, giving us "Wireless Mouse".
6. Handle errors: If a cell has no parentheses, SEARCH will return a #VALUE! error. The IFERROR(..., A2) wrapper tells Excel that if an error occurs, it should simply return the original text untouched.

Method 3: The Office 365 Text Split Method (Simple Formula)

If you don't want to deal with complex regex or math-based replacements, you can use the newer TEXTBEFORE and TEXTAFTER functions to reconstruct your string by skipping the parenthetical part.

The Formula (For text ending with parentheses)

If your bracketed text is always at the end of the string (e.g., "John Doe (Sales)"), you can use this simple approach:

=TRIM(TEXTBEFORE(A2, "("))

If there is text after the parentheses that you want to keep (e.g., "Product (New) Inventory"), you can concatenate the parts before and after:

=TRIM(TEXTBEFORE(A2, "(") & TEXTAFTER(A2, ")", , , , ""))

This extracts everything before the opening parenthesis and merges it with everything after the closing parenthesis.

Method 4: Find and Replace (No Formulas Required)

If you do not need a dynamic formula that updates when values change, you can clean your data in seconds using Excel's built-in Find and Replace utility with wildcards.

Steps to follow:

1. Select the column or range of cells containing the data you want to clean.
2. Press Ctrl + H to open the Find and Replace dialog box.
3. In the Find what box, type: (*) (Note the space before the opening parenthesis. This helps delete the extra space before the bracket).
4. Leave the Replace with box completely empty.
5. Click Replace All.

Method 5: Power Query (For Repeatable Data Pipelines)

If you are building a recurring report and importing data from external CSV or database files, using Power Query to strip parentheses is highly efficient and keeps your workbook fast.

How to do it in Power Query:

1. Select your table, go to the Data tab, and click From Table/Range to open the Power Query Editor.
2. Right-click the column header you want to clean and select Split Column > By Delimiter.
3. Select Custom as the delimiter and enter the open parenthesis character: (. Click OK.
4. This splits your column into two: one with the clean text, and another containing the text inside the parentheses followed by a closing parenthesis.
5. Simply delete the second column, rename your original column, and click Close & Load to return the cleaned data to Excel.

Choosing the Right Tool for the Job

Depending on your version of Excel and your specific dataset, different methods will yield the best results. Refer to this quick-reference table to make your choice:

Conclusion

Cleaning text formatted with parentheses is a common administrative headache in Excel. If you are using modern Excel, leverage the power of REGEXREPLACE to easily strip matching blocks of text without breaking a sweat. For older spreadsheets, the combination of REPLACE, SEARCH, and IFERROR remains a reliable workhorse. Whichever method you choose, automating this cleaning step will save hours of manual data entry and ensure your downstream formulas run smoothly.