This happens all the time. You get a data dump from your main office in London. Can’t wait to start the analysis. Only to find out that the data uses British measurements. What is a stone anyways?
And if you are a chump… like most of us are… you go about looking up a conversion table somewhere on the internet. Copy/paste. Bring it into Excel. Or UDF Functions. YUK.
There is an easier way.
Today’s tip is offered by Kevin Lehrbass of MySpreasheetLab.com. Use the CONVERT Function.
Go over to your Excel help icon and type in “CONVERT”. You will see a ton of items that can be converted. But first things first.
In the example below, I am converting 7 Meters to Feet. There is a number, in this case 7, along with the from_unit and to-unit. The from_unit and to_unit should be in quotes.
OK. Well that’s kind of cool, Rick. But how would I intuitively know that “m” is meters and not minutes. And that “ft” is feet and not fahrenheit? Good question. Below is a handy lookup table for you. If you click the image, it will also download an excel file that has all the units.
If you to to convert minutes to meters. Or inches to celsius, you will get an error.
Convert function spreadsheet <– Click to download the spreadsheet example
Guerrilla Data Analysis Using Microsoft Excel is yours for the taking. Oz mentioned it again in this video, so you should check it out.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.