How to separate a column into two?

I have a column which lists Fund Name and Fund Code. I need to write a formula that will take the code out of the Fund Name and place it into a separate column. For ex: Beacon Inc. (9235). I need to have Beacon Inc in one column and 9235 in another. Thank you for all your help.

Is the code always encompassed in bracket? Can we define the problem as remove "( .. )" from the column and write the info. within the brackes to next col?
A V Veerkar

=LEFT(A1,FIND("(",A1)-1) gives the company name

=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1) gives the fund number.

HTH,

Dave