Stones and Lbs

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

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

Vaya con Dios,
Chuck, CABGx3


"Eamon" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
>
>
>.
>

Hi

I don't think that works if either or both the stone and lbs figures are in single figures.

Try:

=(LEFT(A1,(SEARCH("-",A1)-1))*14)+(RIGHT(A1,LEN(A1)-(SEARCH("-",A1))))

10-4 136
10-5 135
10-6 134
10-7 133
10-8 132
10-9 131
10-10 150
10-11 151
10-12 152
10-13 153
11-0 154
11-1 153
11-2 152
11-3 151
11-4 150
11-5 149
11-6 148
11-7 147
11-8 146
11-9 145
11-10 164
11-11 165
11-12 166
11-13 167
12-0 168
12-1 167
12-2 166
12-3 165
12-4 164
12-5 163
12-6 162
12-7 161

Judith this is what is returned using your formula the correct value is
returned in some cases but the incorrect value is returned in other cases
any other suggestions to remedy this.

Your help is much appreciated.

Regards

Eamon

PS I have it working with
=(LEFT(A1,2)*14)+(RIGHT(A1,1)

Thanks also to Chuck

"JudithJubilee" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
>>.
>>

Still getting some incorrect returns using =(LEFT(A1,2)*14)+(RIGHT(A1,1)
i.e. 10-12 returning 142 instead of 152

Regards

Eamon

"Eamon" <[email protected]> wrote in message
news:[email protected]...
> 10-4 136
> 10-5 135
> 10-6 134
> 10-7 133
> 10-8 132
> 10-9 131
> 10-10 150
> 10-11 151
> 10-12 152
> 10-13 153
> 11-0 154
> 11-1 153
> 11-2 152
> 11-3 151
> 11-4 150
> 11-5 149
> 11-6 148
> 11-7 147
> 11-8 146
> 11-9 145
> 11-10 164
> 11-11 165
> 11-12 166
> 11-13 167
> 12-0 168
> 12-1 167
> 12-2 166
> 12-3 165
> 12-4 164
> 12-5 163
> 12-6 162
> 12-7 161
>
> Judith this is what is returned using your formula the correct value is
> returned in some cases but the incorrect value is returned in other cases
> any other suggestions to remedy this.
>
> Your help is much appreciated.
>
> Regards
>
> Eamon
>
> PS I have it working with
> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>
> Thanks also to Chuck
>
> "JudithJubilee" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>>
>>>
>>>.
>>>
>
>

Hello there again,

Your formula appears to be slightly wrong:

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

The final digit needs to be 2:

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

If this still doesn't work sent out another SOS.

Judith

>-----Original Message-----
> 10-4 136
> 10-5 135
> 10-6 134
> 10-7 133
> 10-8 132
> 10-9 131
> 10-10 150
> 10-11 151
> 10-12 152
> 10-13 153
> 11-0 154
> 11-1 153
> 11-2 152
> 11-3 151
> 11-4 150
> 11-5 149
> 11-6 148
> 11-7 147
> 11-8 146
> 11-9 145
> 11-10 164
> 11-11 165
> 11-12 166
> 11-13 167
> 12-0 168
> 12-1 167
> 12-2 166
> 12-3 165
> 12-4 164
> 12-5 163
> 12-6 162
> 12-7 161
>
>Judith this is what is returned using your formula the
correct value is
>returned in some cases but the incorrect value is
returned in other cases
>any other suggestions to remedy this.
>
>Your help is much appreciated.
>
>Regards
>
>Eamon
>
>PS I have it working with
>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>
>Thanks also to Chuck
>
>"JudithJubilee" <[email protected]>
wrote in message
>news:[email protected]...
>> 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
>>>
>>>
>>>.
>>>
>
>
>.
>

Judith,

Your formula is returning 139 for 10-1 it should return 141?
Your formula is returning the right answer when the Lbs are 0 or (2 digits)
i.e. 10 or 11 or 12 or 13
but is returning the incorrect value when (Lbs are a single digit i.e. 1 or
2 or 3 etc!
Regards,

Eamon
"JudithJubilee" <[email protected]> wrote in message
news:[email protected]...
> Hello there again,
>
> Your formula appears to be slightly wrong:
>
> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>
> The final digit needs to be 2:
>
> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>
> If this still doesn't work sent out another SOS.
>
> Judith
>
>>-----Original Message-----
>> 10-4 136
>> 10-5 135
>> 10-6 134
>> 10-7 133
>> 10-8 132
>> 10-9 131
>> 10-10 150
>> 10-11 151
>> 10-12 152
>> 10-13 153
>> 11-0 154
>> 11-1 153
>> 11-2 152
>> 11-3 151
>> 11-4 150
>> 11-5 149
>> 11-6 148
>> 11-7 147
>> 11-8 146
>> 11-9 145
>> 11-10 164
>> 11-11 165
>> 11-12 166
>> 11-13 167
>> 12-0 168
>> 12-1 167
>> 12-2 166
>> 12-3 165
>> 12-4 164
>> 12-5 163
>> 12-6 162
>> 12-7 161
>>
>>Judith this is what is returned using your formula the
> correct value is
>>returned in some cases but the incorrect value is
> returned in other cases
>>any other suggestions to remedy this.
>>
>>Your help is much appreciated.
>>
>>Regards
>>
>>Eamon
>>
>>PS I have it working with
>>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>
>>Thanks also to Chuck
>>
>>"JudithJubilee" <[email protected]>
> wrote in message
>>news:[email protected]...
>>> 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
>>>>
>>>>
>>>>.
>>>>
>>
>>
>>.
>>

I posted a formula - does it not work?

You can't specify taking a number of digits from the left or right - the formula must calculate this - because sometimes there are single figures and sometimes 2 figures.

Hello there,

Try this:

=(LEFT(A1,2)*14)+(RIGHT(A1,LEN(A1)-FIND("-",A1)))

Judith

>-----Original Message-----
>Judith,
>
>Your formula is returning 139 for 10-1 it should return
141?
>Your formula is returning the right answer when the Lbs
are 0 or (2 digits)
>i.e. 10 or 11 or 12 or 13
>but is returning the incorrect value when (Lbs are a
single digit i.e. 1 or
>2 or 3 etc!
>Regards,
>
>Eamon
>"JudithJubilee" <[email protected]>
wrote in message
>news:[email protected]...
>> Hello there again,
>>
>> Your formula appears to be slightly wrong:
>>
>> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>
>> The final digit needs to be 2:
>>
>> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>>
>> If this still doesn't work sent out another SOS.
>>
>> Judith
>>
>>>-----Original Message-----
>>> 10-4 136
>>> 10-5 135
>>> 10-6 134
>>> 10-7 133
>>> 10-8 132
>>> 10-9 131
>>> 10-10 150
>>> 10-11 151
>>> 10-12 152
>>> 10-13 153
>>> 11-0 154
>>> 11-1 153
>>> 11-2 152
>>> 11-3 151
>>> 11-4 150
>>> 11-5 149
>>> 11-6 148
>>> 11-7 147
>>> 11-8 146
>>> 11-9 145
>>> 11-10 164
>>> 11-11 165
>>> 11-12 166
>>> 11-13 167
>>> 12-0 168
>>> 12-1 167
>>> 12-2 166
>>> 12-3 165
>>> 12-4 164
>>> 12-5 163
>>> 12-6 162
>>> 12-7 161
>>>
>>>Judith this is what is returned using your formula the
>> correct value is
>>>returned in some cases but the incorrect value is
>> returned in other cases
>>>any other suggestions to remedy this.
>>>
>>>Your help is much appreciated.
>>>
>>>Regards
>>>
>>>Eamon
>>>
>>>PS I have it working with
>>>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>
>>>Thanks also to Chuck
>>>
>>>"JudithJubilee" <[email protected]>
>> wrote in message
>>>news:[email protected]...
>>>> 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
>>>>>
>>>>>
>>>>>.
>>>>>
>>>
>>>
>>>.
>>>
>
>
>.
>

Judith,

This is perfect.
Thank you very much for your help, much appreciated.

Regards,

Eamon
"JudithJubilee" <[email protected]> wrote in message
news:[email protected]...
> Hello there,
>
> Try this:
>
> =(LEFT(A1,2)*14)+(RIGHT(A1,LEN(A1)-FIND("-",A1)))
>
> Judith
>
>>-----Original Message-----
>>Judith,
>>
>>Your formula is returning 139 for 10-1 it should return
> 141?
>>Your formula is returning the right answer when the Lbs
> are 0 or (2 digits)
>>i.e. 10 or 11 or 12 or 13
>>but is returning the incorrect value when (Lbs are a
> single digit i.e. 1 or
>>2 or 3 etc!
>>Regards,
>>
>>Eamon
>>"JudithJubilee" <[email protected]>
> wrote in message
>>news:[email protected]...
>>> Hello there again,
>>>
>>> Your formula appears to be slightly wrong:
>>>
>>> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>
>>> The final digit needs to be 2:
>>>
>>> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>>>
>>> If this still doesn't work sent out another SOS.
>>>
>>> Judith
>>>
>>>>-----Original Message-----
>>>> 10-4 136
>>>> 10-5 135
>>>> 10-6 134
>>>> 10-7 133
>>>> 10-8 132
>>>> 10-9 131
>>>> 10-10 150
>>>> 10-11 151
>>>> 10-12 152
>>>> 10-13 153
>>>> 11-0 154
>>>> 11-1 153
>>>> 11-2 152
>>>> 11-3 151
>>>> 11-4 150
>>>> 11-5 149
>>>> 11-6 148
>>>> 11-7 147
>>>> 11-8 146
>>>> 11-9 145
>>>> 11-10 164
>>>> 11-11 165
>>>> 11-12 166
>>>> 11-13 167
>>>> 12-0 168
>>>> 12-1 167
>>>> 12-2 166
>>>> 12-3 165
>>>> 12-4 164
>>>> 12-5 163
>>>> 12-6 162
>>>> 12-7 161
>>>>
>>>>Judith this is what is returned using your formula the
>>> correct value is
>>>>returned in some cases but the incorrect value is
>>> returned in other cases
>>>>any other suggestions to remedy this.
>>>>
>>>>Your help is much appreciated.
>>>>
>>>>Regards
>>>>
>>>>Eamon
>>>>
>>>>PS I have it working with
>>>>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>>
>>>>Thanks also to Chuck
>>>>
>>>>"JudithJubilee" <[email protected]>
>>> wrote in message
>>>>news:[email protected]...
>>>>> 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
>>>>>>
>>>>>>
>>>>>>.
>>>>>>
>>>>
>>>>
>>>>.
>>>>
>>
>>
>>.
>>

Hello Eamon,

Glad to be of service

Judith

>-----Original Message-----
>Judith,
>
>This is perfect.
>Thank you very much for your help, much appreciated.
>
>Regards,
>
>Eamon
>"JudithJubilee" <[email protected]>
wrote in message
>news:[email protected]...
>> Hello there,
>>
>> Try this:
>>
>> =(LEFT(A1,2)*14)+(RIGHT(A1,LEN(A1)-FIND("-",A1)))
>>
>> Judith
>>
>>>-----Original Message-----
>>>Judith,
>>>
>>>Your formula is returning 139 for 10-1 it should return
>> 141?
>>>Your formula is returning the right answer when the Lbs
>> are 0 or (2 digits)
>>>i.e. 10 or 11 or 12 or 13
>>>but is returning the incorrect value when (Lbs are a
>> single digit i.e. 1 or
>>>2 or 3 etc!
>>>Regards,
>>>
>>>Eamon
>>>"JudithJubilee" <[email protected]>
>> wrote in message
>>>news:[email protected]...
>>>> Hello there again,
>>>>
>>>> Your formula appears to be slightly wrong:
>>>>
>>>> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>>
>>>> The final digit needs to be 2:
>>>>
>>>> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>>>>
>>>> If this still doesn't work sent out another SOS.
>>>>
>>>> Judith
>>>>
>>>>>-----Original Message-----
>>>>> 10-4 136
>>>>> 10-5 135
>>>>> 10-6 134
>>>>> 10-7 133
>>>>> 10-8 132
>>>>> 10-9 131
>>>>> 10-10 150
>>>>> 10-11 151
>>>>> 10-12 152
>>>>> 10-13 153
>>>>> 11-0 154
>>>>> 11-1 153
>>>>> 11-2 152
>>>>> 11-3 151
>>>>> 11-4 150
>>>>> 11-5 149
>>>>> 11-6 148
>>>>> 11-7 147
>>>>> 11-8 146
>>>>> 11-9 145
>>>>> 11-10 164
>>>>> 11-11 165
>>>>> 11-12 166
>>>>> 11-13 167
>>>>> 12-0 168
>>>>> 12-1 167
>>>>> 12-2 166
>>>>> 12-3 165
>>>>> 12-4 164
>>>>> 12-5 163
>>>>> 12-6 162
>>>>> 12-7 161
>>>>>
>>>>>Judith this is what is returned using your formula
the
>>>> correct value is
>>>>>returned in some cases but the incorrect value is
>>>> returned in other cases
>>>>>any other suggestions to remedy this.
>>>>>
>>>>>Your help is much appreciated.
>>>>>
>>>>>Regards
>>>>>
>>>>>Eamon
>>>>>
>>>>>PS I have it working with
>>>>>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>>>
>>>>>Thanks also to Chuck
>>>>>
>>>>>"JudithJubilee" <[email protected]>
>>>> wrote in message
>>>>>news:[email protected]...
>>>>>> 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
>>>>>>>
>>>>>>>
>>>>>>>.
>>>>>>>
>>>>>
>>>>>
>>>>>.
>>>>>
>>>
>>>
>>>.
>>>
>
>
>.
>

I don't know if this is an issue in this case, but if the searched cell is
eg 9-10, your formula results in an #VALUE error.

Try this

=(LEFT(A1,(FIND("-",A1)-1))*14)+(RIGHT(A1,LEN(A1)-FIND("-",A1)))

Ian

"JudithJubilee" <[email protected]> wrote in message
news:[email protected]...
> Hello there,
>
> Try this:
>
> =(LEFT(A1,2)*14)+(RIGHT(A1,LEN(A1)-FIND("-",A1)))
>
> Judith
>
>>-----Original Message-----
>>Judith,
>>
>>Your formula is returning 139 for 10-1 it should return
> 141?
>>Your formula is returning the right answer when the Lbs
> are 0 or (2 digits)
>>i.e. 10 or 11 or 12 or 13
>>but is returning the incorrect value when (Lbs are a
> single digit i.e. 1 or
>>2 or 3 etc!
>>Regards,
>>
>>Eamon
>>"JudithJubilee" <[email protected]>
> wrote in message
>>news:[email protected]...
>>> Hello there again,
>>>
>>> Your formula appears to be slightly wrong:
>>>
>>> =(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>
>>> The final digit needs to be 2:
>>>
>>> =(LEFT(A1,2)*14)+(RIGHT(A1,2))
>>>
>>> If this still doesn't work sent out another SOS.
>>>
>>> Judith
>>>
>>>>-----Original Message-----
>>>> 10-4 136
>>>> 10-5 135
>>>> 10-6 134
>>>> 10-7 133
>>>> 10-8 132
>>>> 10-9 131
>>>> 10-10 150
>>>> 10-11 151
>>>> 10-12 152
>>>> 10-13 153
>>>> 11-0 154
>>>> 11-1 153
>>>> 11-2 152
>>>> 11-3 151
>>>> 11-4 150
>>>> 11-5 149
>>>> 11-6 148
>>>> 11-7 147
>>>> 11-8 146
>>>> 11-9 145
>>>> 11-10 164
>>>> 11-11 165
>>>> 11-12 166
>>>> 11-13 167
>>>> 12-0 168
>>>> 12-1 167
>>>> 12-2 166
>>>> 12-3 165
>>>> 12-4 164
>>>> 12-5 163
>>>> 12-6 162
>>>> 12-7 161
>>>>
>>>>Judith this is what is returned using your formula the
>>> correct value is
>>>>returned in some cases but the incorrect value is
>>> returned in other cases
>>>>any other suggestions to remedy this.
>>>>
>>>>Your help is much appreciated.
>>>>
>>>>Regards
>>>>
>>>>Eamon
>>>>
>>>>PS I have it working with
>>>>=(LEFT(A1,2)*14)+(RIGHT(A1,1)
>>>>
>>>>Thanks also to Chuck
>>>>
>>>>"JudithJubilee" <[email protected]>
>>> wrote in message
>>>>news:[email protected]...
>>>>> 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
>>>>>>
>>>>>>
>>>>>>.
>>>>>>
>>>>
>>>>
>>>>.
>>>>
>>
>>
>>.
>>

Eamon wrote...
>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)?

While your problem has already been solved, there's an easier way.

=(SUBSTITUTE("10-12","-","")&"/14")*14

returns 152.

Thanks also to Ian and Harlan your suggestions are much appreciated.

Regards,

Eamon


"Harlan Grove" <[email protected]> wrote in message
news:[email protected]...
> Eamon wrote...
>>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)?
>
> While your problem has already been solved, there's an easier way.
>
> =(SUBSTITUTE("10-12","-","")&"/14")*14
>
> returns 152.
>

Harlan Grove wrote...
>=(SUBSTITUTE("10-12","-","")&"/14")*14

I don't know how the space got lost, but the formula should be

=(SUBSTITUTE("10-12","-"," ")&"/14")*14