try this

Sheet12

A B 1 4/5 0.8 2 6/4 1.5 3 3/1 3 4 2/5 0.4 5 4/5 0.8

Worksheet Formulas

Cell Formula B1 =LEFT(A1,SEARCH("/",A1)-1)/RIGHT(A1,LEN(A1)-SEARCH("/",A1)) B2 =LEFT(A2,SEARCH("/",A2)-1)/RIGHT(A2,LEN(A2)-SEARCH("/",A2)) B3 =LEFT(A3,SEARCH("/",A3)-1)/RIGHT(A3,LEN(A3)-SEARCH("/",A3)) B4 =LEFT(A4,SEARCH("/",A4)-1)/RIGHT(A4,LEN(A4)-SEARCH("/",A4)) B5 =LEFT(A5,SEARCH("/",A5)-1)/RIGHT(A5,LEN(A5)-SEARCH("/",A5))

## Like this thread? Share it with others