Excel: Power Query – The Simplest Way to Convert Stones and Pounds to KG

Channel Avatar
Comment
X
Share
Excel: Power Query - The Simplest Way to Convert Stones and Pounds to KG
Excel: Power Query – The Simplest Way to Convert Stones and Pounds to KG
Learn how to convert weight stored as stones and pounds into kilograms. It should be straightforward but this example has the added complication of the weight value being stored in a single cell in the format of /”10st 10lbs/”. Need a quick way to clean up the data and do the conversion? Power Query to the rescue!

Notes and Resources
Download a copy of the files used in this video: https://app.box.com/s/zf79agkcuv77b9q8et1y0pvhpci60gu9

MoreQuery Addin (for Mac Users): https://youtu.be/ZTiIJflH6S0
CONVERT Function Tutorial: https://youtu.be/eVEgNbEgY7E

Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

‍️ Let’s connect on social
Twitter: https://twitter.com/theexceltrainer
Facebook: https://www.facebook.com/theexceltrainer
LinkedIn: https://www.linkedin.com/in/thomasmik

#excel #powerquery #weighttracker

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *