Removing the trailing string within parentheses in excel

[Aruna Kallu]

Some of the values in column G end with text surrounded by parenthesis. For example "(Prod Ops)" or "(Limited Access Role)". I am looking to get all occurrences of the text (including parenthesis) removed. In some cases the values have parenthesis and text in the middle of the field (ex. BRASS(DSL) Dev/Test. That should not be changed. I only want the trailing text in parenthesis removed.

Once that text is removed, I would also need any remaining trailing blanks in that column removed.

Can someone help in getting this done?

 

[mart37]

=TRIM(LEFT(G2,FIND(CHAR(1);SUBSTITUTE(G2,"(",CHAR(1),LEN(G2)-LEN(SUBSTITUTE(G2,"(",""))))-1))

 

[jtakw]

Hi,

Based on you description and Limited sample, try this:

Book3.xlsx
	A	B
1	BRASS(DSL) Dev/Test (Prod Ops)	BRASS(DSL) Dev/Test
2	BRASS(DSL) Dev/Test	BRASS(DSL) Dev/Test
3	BRASS Dev/Test	BRASS Dev/Test
4	BRASS Dev/Test (Limited Access Role)	BRASS Dev/Test
Sheet827

Cell Formulas
Range	Formula
B1:B4	B1	=IFERROR(TRIM(LEFT(SUBSTITUTE(A1,"(",REPT(" ",255),IF(FIND(")",A1)=LEN(A1),1,2)),255)),A1)