Displaying a figure from the end of a cell without the brackets

[thegreengrocer]

hi, i would like a formula to go in B1 that would return just 1.8 from A1 without the brackets please, many thanks in advance.

Excel Workbook
	A	B
1	Apple (1.8)	1.8
2	Tomato (1.8)
3	Orange (1.88)
4	Apple (1.95)
5	Banana (2)
Sheet1

 

[VoG]

Try

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)+0

 

[thegreengrocer]

That works a treat, thank you very much for the immediate response!