=left =right or =mid formula

[ronie85]

I need a formula either =left, =right or =mid to give me the contents between the brackets as of below. So I need ‘15/8’ on the first row to be displayed, ‘4’ on the second, ‘17/11’ and ‘11/10’.

[TABLE="width: 137"]
<tbody>[TR]
[TD]QPR (15/8)
[/TD]
[/TR]
[TR]
[TD]Aston Villa (4)
[/TD]
[/TR]
[TR]
[TD]Burnley (17/11)
[/TD]
[/TR]
[TR]
[TD]Newcastle (11/10)
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Try...

=SUBSTITUTE(REPLACE(A2,1,FIND("(",A2),""),")","")

 

[johnmpl]

Hi!

Try this formula:
=SUBSTITUTE(MID(A1,FIND("(",A1)+1,100),")","")

Blessings!

 

[ronie85]

That worked a treat!! Thanks a lot Aladin!