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 :

Please Login or Register  to view this content.

I want to trim off the

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

**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:

Please Login or Register  to view this content.

Re: How to trim characters after bracket bracket by formula