Remove String Within the Bracket and also the Bracket

**seanyeap** · 04-22-2010, 05:35 AM

Hi All,
I need formula to remove a string or text within a bracket. For instance, (abc) to become abc or [abc] to become abc. Thanks in advance.

**Andy Pope** · 04-22-2010, 05:41 AM

Your description seems more like remove the brackets.

Remove String Within a Bracket

(ABC) would become ()
[ABC] would become []

=SUBSTITUTE(SUBSTITUTE(A1,")",""),"(","")

Modify for square brackets or nest 2 more SUBSTITUTES if both bracket types are required.

**seanyeap** · 04-22-2010, 11:57 AM

Hi Andy,
I have edited the subject. A1 is 123(abc), I want the result is 123. I have tried =LEFT(A1,FIND(" ",A1)), but it does not return the result I want. Thanks again.

**seanyeap** · 04-22-2010, 12:22 PM

Hi Andy,
I think this =LEFT(A1,FIND("(",A1,1)-1) solved my problem.

**seanyeap** · 04-22-2010, 11:10 PM

Hi,
How do I incorporate =LEFT(A1,FIND("(",A1,1)-1) with =SUBSTITUTE((A1&" "&A2&" "&A3)," "," + ")? The aim is to delete string within the bracket then to join with "+" sign. Please refer to my attachment for better understanding. Thank you.