Extract number from variable text string

[OneEyedBartender]

Hi there,

I would like to extract the number in between the () in the following data set:

<TABLE style="WIDTH: 252pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=336 border=0 x:str><COLGROUP><COL style="WIDTH: 252pt; mso-width-source: userset; mso-width-alt: 12288" width=336><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 252pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=336 height=17>(5) Demands 8/9/06</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Dmnd (59) 11/13/06
(5) Dmnds 12/4/06
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>(5) Dmnds 5/17/06
Dmnd (59) 11/13/06
</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>(5) Dmnds 5/17/06

</TD></TR></TBODY></TABLE>
I found the following formula that works when the numbers are on the left but I would like one formula that I can copy and paste down 2000 rows:

=MID(TRIM(LEFT(SUBSTITUTE(C474," ",REPT(" ",99)),99)),2,LEN(TRIM(LEFT(SUBSTITUTE(C474," ",REPT(" ",99)),99)))-2)

Thanks!

 

[Jonmo1]

=mid(a1,find("(",a1)+1,find(")",a1)-find("(",a1)-1)

 

[onlyadrafter]

Hello,

this works for your examples

=MID(A16,FIND("(",A16)+1,FIND(")",A16)-FIND("(",A16)-1)

 

[OneEyedBartender]

Perfect, thank you both!