Need help with MID formula to get the results within the parenthesis

I have several hundred lines of data month over month where I am looking to quantify the number of lines for each company. Some companies have different divisions so I just need to extract the given company ID # within the parenthesis. Then I will do an index match separately to put the company ID# with the parent company name.

For some reason when I use the below formula I get an error " you have too few arguments for this function"

=MID(B3, SEARCH(“(“, B3)+1, SEARCH(“)”,B1) – SEARCH(“(“,B1)-1)

But when I use this formula I get too much info

=MID(B2, SEARCH("(",B2) + 1, SEARCH(")",B2,SEARCH(")",B2)+1) - SEARCH("(",B2) - 1)

Can someone help settle on the formula where I just want to get the results within the parenthesis. Below is an example of a line of data

American Transfer Partners (0112015) - ATP-ENERGY TRANSFER ACTIVE (A19)

Thanks

Your first formula looks at B3, and B1
Your 2nd formula looks at a single cell. B2

You might adjust the ranges as needed.

This works-- thank you for your help.