Editing data, want to remove brackets

[beanpeon]

I've got two large columns of numerical data, some of which have the figure I want + (.....)

I want to remove the brackets and whatever it's contents throughout the sheet.

Not knowing how long the contents of the brackets are has confused me.

I know that the figure I want to keep will always end going from the left 2 digits after the first decimal place.

I've tried using LEFT/RIGHT/MID but cant work out how to make it conditional to the above. Any help pls?

Thanks in advance if you read this far

 

[mikerickson]

Try
=TRIM(LEFT(SUBSTITUTE(A1,"(",REPT(" ",255)),255)+0

If the currency sign is text in the cell rather than formatting, omit the +0

 

[beanpeon]

Try
=TRIM(LEFT(SUBSTITUTE(A1,"(",REPT(" ",255)),255)+0

If the currency sign is text in the cell rather than formatting, omit the +0

Thank you very much that's excellent.

So this selects from the first bracket and then replaces any contents up to length 255 is that right?


Thanks so much for the quick response