Try the below with the data in cell A1

in B1
=MID(A1,FIND("/",A1)+1,10)-LEFT(A1,FIND("/",A1)-1)

If this post helps click Yes
---------------
Jacob Skaria


"Tony S." wrote:

I have several cell that each contain (2) numbers separated by "/".
i.e. 1/5, 7/29, 5/187, 42/169 etc.
I want to subtract the numerator form the denominator not divide them. The
results would be:
4, 22, 182, 127

Can someone help with this? Thanks!

--
Tony S.