left,right,mid with conditions?

[burdo77]

I have a cell that contains 8/303 (50.0) in cell B1.

I want to take the data before the / in cell C1

I want the data to the right of the / but before the brackets in D1

I want all data within the brackets in E1

It has to be conditional cause the numbers can be single, double or triple digits.

regards,

burdo

[pangam_s@yahoo.com]

Cell C1=LEFT(B1,FIND("/",B1)-1)
D1= MID(B1,FIND("/",B1)+1,(FIND("(",B1)-FIND("/",B1)-1))
E1=MID(B1,FIND("(",B1)+1,(FIND(")",B1)-FIND("(",B1)-1))

Regards,
Suhas

[alansidman]

In B1 =LEFT(A1,FIND("/",A1)-1)
In C1 =MID(A1,FIND("/",A1)+1,FIND("(",A1)-FIND("/",A1)-1)
In D1 =RIGHT(A1,LEN(A1)-FIND("(",A1)+1)

Assumes data is in A1

[burdo77]

these responses were top class and both work, thanks for your help.

regards,

burdo