Extract part of a line and paste in another cell

[kmlartigue]

Is there a code to extrat the part just inside the () and place it in another cell?

For example, TESTER ACCOUNT TR (444444444) , extract just 444444444 and place it in another cell?

[mdmackillop]

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

[kmlartigue]

See the attached Test.xlsx file. I keep getting an error when I run that code. Again, I am trying to extract the number inside the ( ) in B3 and place that number in A3.

[kmlartigue]

Nevermind on error issues - the code works! Thank you!