how to extract data from strings containing multiple parentheses?

I'm looking for Excel code (no VBA please) to extract Columns B & C from Column A (desired results shown below, also sample spreadsheet attached). I've used LEFT, RIGHT, MID, LEN, SUBSTITUTE, etc. many times for extraction, but can't get it to work with multiple parentheses. Note that they may appear at the middle, end, 1 set, 2 sets, 3 sets, or not at all.


Column A Column B Column C
Reserve Bid (Pine Bluff) Rerserve Bid Pine Bluff
Louve des Reves (IRE) (Sadler's Wells) Louve des Reves (IRE) Sadler's Wells
Stormy Lanae' (Johar) Stormy Lanae' Johar
Spelling (Alphabet Soup) Spelling Alphabet Soup
Parvana (IRE) (Galileo (IRE)) Parvana (IRE) Galileo (IRE)
City of Light (FR) (Kingsalsa) City of Light (FR) Kingsalsa
Ladywell Court (Powerscourt (GB)) Ladywell Court Powerscourt (GB)

Originally Posted by mehmetcik

Formula for B1 =IF(ISERROR(FIND(") (",A1)),LEFT(A1,FIND("(",A1)-2),LEFT(A1,FIND(") (",A1)))

Formula for c1 =IF(ISERROR(FIND(") (",A1)),MID(A1,FIND("(",A1)+1,LEN(A1)-LEN(B1)-3),MID(A1,FIND(") (",A1)+3,LEN(A1)-LEN(B1)-3))

Thank you SO MUCH! That's exactly what I needed. I was in the ballpark ... not sure I would've ever matched your formulas though.

ABC CO > Executive (Tom Johnson) > Accounts Payable (Mary Price) > Accounts Receivable (Tom Reynolds) > Payment Processing (Sharon Adams) > Service Department (Julie Thomas) > Finance Team (Tom Attwood) > Service Front Department (David Cohen) > Fulfillment (Shannon Jones)

Is there an excel formula where I can extract all of the names in parentheses that's in cell A1? If possible, I like to have it extract one full name per cell individually. Another option I can use is if I can have it give me the name of the 4th person listed in the hierarchy chain.