=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
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks