=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