How to extract "4/5.00" from cell with value "1.29(4/5.00 SAL)

[texhorn92]

What formula can I use to get this? Also, can someone explain why it works? I tried using something like this, but no success:
--MID(F2,FIND("(",F2)+1,10)

Thank you!

 

[FlameRetired]

You are welcome. Thank you for the feedback.

In that case this works.

=TEXT(LOOKUP(1E+306,--LEFT(REPLACE(A4,1,FIND("/",A4),""),ROW($1:$30))),"0.00")