Hello there,

You need to extract the left 2 digits and times by 14
plus the right 2 digits:

A1 = 10-12

=(LEFT(A1,2)*14)+(RIGHT(A1,2))

Hope this helps

Judith

>-----Original Message-----
>Hi,
>
>How can I convert Stones and Lbs to Lbs
>i.e. in A1 10-12 (10st - 12Lbs) what formula could I use
in B1 to return 152
>(lbs)?
>
>Any suggestions would be most welcome.
>
>Regards,
>
>Eamon
>
>
>.
>