Tip Printed from ExcelTip.com

---

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


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").