Extracting numerical data from brackets

[gapink]

I can't believe what wonderful experts are out there

Help Test Page-2.xls

[:) Sixthsense :)]

=if(iserr(value(mid(a3,find("(",a3)+1,(find(")",a3)-find("(",a3))-1))),"",value(mid(a3,find("(",a3)+1,(find(")",a3)-find("(",a3))-1)))

[gapink]

How does this work with different number of open btackets to closed brackets

[Ghozi Alkatiri]

=--trim(substitute(mid(left(a3;len(a3)-1);find("(";a3)+1;len(a3));")";""))

[Ghozi Alkatiri]

try it my be this formula is better than before.

=--MID(A3;FIND("(";A3)+1;(FIND(")";A3)-FIND("(";A3)-1))

see attachment to compare with another condition.

[e.isayev]

=value(mid(a3,find("(",a3,1)+1,find(")",a3,1)-find("(",a3,1)-1))

[Teethless mama]

=trim(mid(substitute(substitute(a3,"(",rept(" ",99)),")",rept(" ",99)),99,99))+0

[Pepe Le Mokko]

Perhaps

=IF(ISERROR(FIND(")",A1)),"",IF(ISERROR(FIND("(",A1)),"",LEFT(RIGHT(A1,LEN(A1)-FIND("(",A1)),FIND(")",RIGHT(A1,LEN(A1)-FIND("(",A1)))-1)))