CONVERT Units of Measure
There are times I need to quickly convert a quantity from one unit of measure to another (inch, foot), or from one system of measurement to another (metric, imperial). For example, when I am entering meals into MyFitnessPal, preparing a meal in the kitchen, or working on a project in the garage. When I need to quickly know how many ounces are in a cup, how many feet are in a meter, or how many liters are in a gallon, I usually just ask Siri or Alexa. But, when there are many conversions or the data is in Excel, we can use Excel’s CONVERT function to help out.
The CONVERT function allows us to convert a quantity from one unit of measure to another. The basic syntax is:
CONVERT(number, from_unit, to_unit)
For example, CONVERT(1, “cup”, “oz”) would return 8.
But, instead of entering each argument value directly into the function, we can store them in cells. For example, we could store the arguments in cells like this:
In E7, we could write the following formula:
=CONVERT(B7, C7, D7)
We then fill the formula down:
This function supports many options for length, time, weight, volume, temperature, and more. For example, gram, ton, meter, parsec, light year, yard, hour, minute, year, watt, fahrenheit, celsius, teaspoon, tablespoon, ounce, cup, quart, gallon, liter, and so many others.
The function uses traditional abbreviations, which are conveniently displayed as you write the function:
If I’m just doing a single quick conversion, I’m likely to use a voice assistant or Google. But, when I have many conversions or when the data is in Excel, the CONVERT function is a really nice option.
If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.
Want to learn Excel?
Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)