How to trim characters after bracket bracket by formula

**ad9051** · 07-18-2014, 02:55 AM

Hey guys,

I have a load of data formated as such :

12345 (241)

I want to trim off the

(241)

how do I do this via formula?

Cheers

Alan

**Glenn Kennedy** · 07-18-2014, 02:58 AM

Hard to be exact without a few typical examples, but if its the stuff to the left of the bracket you want, use this:

Formula:

=LEFT(A1,FIND("(",A1)-1)

**Glenn Kennedy** · 07-18-2014, 03:00 AM

Your description was a little ambiguous. Soooo. If it's the brcketed stuff you want to keep, use this:

Formula:

=MID(A1,FIND("(",A1),255)

Re: How to trim characters after bracket bracket by formula