Subtracting not Dividing

[Tony S.]

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!

 

[Jacob Skaria]

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

 

[Tony S.]

Excellent.... it works perfectly. Thank you Jacob.