These 2 may be of use:-


Divides the bits after the /
=MID(A1,(FIND("/",A1,1)+1),99)/MID(B1,(FIND("/",B1,1)+1),99)

Divides the bits before the /
=LEFT(A1,((FIND("/",A1,1))-1))/LEFT(B1,((FIND("/",B1,1))-1))

Mike

"Arithmetic functions with embedded text" wrote:

I have data entered in one cell in this format: 80/60

and I would like to find the difference of that cell with one of similar
format...75/57

by subtracting 75-80 and 57-60.

How can I do this with the / embedded within the cell.

Perhaps just entering the data with a "," instead would help?