In A1 enter:
202
In B1 enter:
=A1*0.0714285781774163
In C1 enter:
=INT(B1)
In D1 enter:
=INT((B1-INT(B1))/0.0714285781774163)
In E1 enter:
=C1 & " st " & D1 & " lb"
and you will see:
202 14.42857279 14 6 14 st 6 lb
You can hide the intermediate columns if you like.
I think the OP wanted it the other way round, & wanted the input to be "14
st 6 lb".
In that case the output in pounds from that input would be something like
=14*(LEFT(A1,FIND("st",A1)-1))+(MID(A1,FIND("st",A1)+2,(FIND("lb",A1)-FIND("st",A1)-2)))but you may need to play around a bit depending on spaces in the inputstring.Again you might decide to produce intermediate columns (hidden if you want)such as=LEFT(A1,FIND("st",A1)-1) for the stones, and=MID(A1,FIND("st",A1)+2,(FIND("lb",A1)-FIND("st",A1)-2)) for the pounds, &then combine them.--David Biddulph