Writing Stones and Pounds into Excel

[Jaffabfc]

Hi,

I am currently on a journey of losing weight and trying to keep a record of it but i have to go on a website and convert 15st 11lb (example) to a numberic number to workout the pounds i have lost.

So 15st 11lb i would have to input 15.7857 and then use convert(xxx,"stone","lbm") to show the pounds and then workout my loss.
But i dont want to be going to a website to work it out everytime.

The website i use is coolconversion.com

Can someone help me.
thanks

 

[Jaffabfc]

Bang on, brilliant exactly what i wanted.

I will try and remember the textsplit formula going forward, i have used it in the past but totally forgot about it.
Can i ask what does it mean with the letter w?

 

[Fluff]

The w is just a variable & you can call it what you like.