» Removing Redundant Characters from a Range of Cells and Resetting the Format

CATEGORY - Excel Text Formulas VERSION - All Microsoft Excel Versions

Problem:

The text values in the range A2:A5 contain redundant parentheses.
We want to create a formula that will remove the parentheses and set the format of the cells to "general".

Solution:

Use the TEXT, TRIM, and SUBSTITUTE functions as shown in the following formula:
=TEXT(TRIM(SUBSTITUTE(SUBSTITUTE(A2,")",""),"(","")),"General").
Screenshot // Removing Redundant Characters from a Range of Cells and Resetting the Format