If you want to convert measurements in Excel, you have come to the right place. Here, we will walk you through 2 quick and effective methods to do the task smoothly.
We can convert measurements by using the CONVERT function and by applying generic formulas. Both of these methods are quick and effective. We will demonstrate these methods in the following article. Here we used Excel 365. You can use any available Excel version.
1. Using CONVERT Function to Convert Measurements in Excel
In this method, we will use the CONVERT function to convert measurements in Excel. You can convert various types of measurements with this function. Among them, we will describe 5 examples.
1.1. Converting Inch to Foot
The following table has Name, Height (Inch), and Height (Foot) columns. Here, we will show you how to convert Height (Inch) to Height (Foot) by using the CONVERT function.
Steps:
- First, we will type =CONVERT in cell D5.
- After that, we will select cell C5 as a number.
Now, can see that there is a list for from_units. It is the unit for the number. You will find your desired unit for number in this list.
- After that, as we want to convert from the Inch unit, we will select “in”.
Next, we will see a to_unit list. It is the unit of the result.
- Afterward, as we want to convert the inch to the foot, we will select “ft” as to_unit.
Finally, the formula becomes as follows:
=CONVERT(C5,"in","ft")
Formula Breakdown
The CONVERT function converts one measurement to another.
- C5 is the number that we want to convert, which is 70.
- “in” is the from_unit, it is the unit of the number. And this unit will get converted.
- “ft” is the to_unit, it is the unit of the result. And we want this unit after conversion.
- Output: 5.83
- Afterward, press ENTER. Then, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the converted height from inch to foot in the Height (Foot) column.
Read More: How to Convert Decimal Feet to Feet and Inches in Excel (3 Methods)
1.2. Transforming Celsius to Fahrenheit
Here, we will convert Celsius to Fahrenheit by using the CONVERT function.
Steps:
- First, we will type the following formula in cell D5.
=CONVERT(C5,"C","F")
Formula Breakdown
The CONVERT function converts one measurement to another.
- C5 is the number that we want to convert, which is 30.
- “C” is the from_unit, it is the unit of the number. And this unit will get converted.
- “F” is the unit_to, it is the unit of the result. And we want this unit after conversion.
- Output: 86
- Then, press ENTER. Afterward, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the converted temperature from Celsius to Fahrenheit in the Temperature (Fahrenheit) column.
1.3. Changing Minutes to Seconds
Here, we will convert minute to second by using the CONVERT function.
Steps:
- First, we will type the following formula in cell D5.
=CONVERT(C5,"mn","sec")
Formula Breakdown
The CONVERT function converts one measurement to another.
- C5 is the number that we want to convert, which is 50.
- “mn” is the from_unit, it is the unit of the number. And this unit will get converted.
- “sec” is the unit_to, it is the unit of the result. And we want this unit after conversion.
- Output: 3000
- Afterward, press ENTER. Then, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the converted time from minute to second in the Exercise Time (Second) column.
Similar Readings
- How to Convert Feet to Meters in Excel (4 Simple Methods)
- Convert Meters to Feet in Excel (4 Useful Methods)
- How to Convert Feet to Inches in Excel (4 Quick Methods)
- Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
1.4. Converting Gram to Pound
Here, we will convert the gram to the pound by using the CONVERT function.
Steps:
- First, we will type the following formula in cell D5.
=CONVERT(C5,"g","lbm")
Formula Breakdown
The CONVERT function converts one measurement to another.
- C5 is the number that we want to convert, which is 500.
- “g” is the from_unit, it is the unit of the number. And this unit will get converted.
- “lbm” is the unit_to, it is the unit of the result. And we want this unit after conversion.
- Output: 1.10
- Then, press ENTER. Afterward, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the converted weight from gram to pound in the Weight (Pound) column.
Read More: How to Convert Kg to Lbs in Excel (4 Easy Methods)
1.5. Converting Liter to Gallon
Here, we will convert the liter to the gallon by using the CONVERT function.
Steps:
- First, we will type the following formula in cell D5.
=CONVERT(C5,"l","gal")
Formula Breakdown
The CONVERT function converts one measurement to another.
- C5 is the number that we want to convert, which is 4.
- “l” is the from_unit, it is the unit of the number. And this unit will get converted.
- “gal” is the unit_to, it is the unit of the result. And we want this unit after conversion.
- Output: 1.06
- Then, we will press ENTER. Next, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, we can see the converted volume from liter to gallon in the Volume (Gallon) column.
2. Applying Generic Formula to Convert Measurements in Excel
In this method, we will use the generic formula to convert measurements in Excel. If you know the conversion units you can easily apply the generic formula. Here, we describe 2 examples.
2.1. Converting Meter to Centimeter
Here, we will convert Height (Meter) to Height (Centimeter).
We know that 1 meter = 100 centimeters. Therefore, we will multiply the meter value by 100 to get the centimeter value.
Steps:
- First, we will type the following formula in cell D5.
=C5*100
Here, we multiply cell C5 which has a value of 1.778 by 100 to get the result in centimeters.
- After that, press ENTER. Next, we will see the result in cell D5.
- Then, we will drag down the formula with the Fill Handle tool.
Finally, in the Height (Centimeter) column, we can see the converted result.
Read More: How to Convert Meters to Miles in Excel (3 Simple Methods)
2.2. Changing Hour to Seconds
Here, we will convert Study Time (Hour) to Study Time (Second).
We know that 1 hour = 3600 Seconds. Therefore, we will multiply the hour value by 3600 to get the second value.
Steps:
- First, we will type the following formula in cell D5.
=C5*3600
Here, we multiply cell C5 which has a value of 5 by 3600 to get the result in seconds.
- Afterward, press ENTER. Then, we will see the result in cell D5.
- After that, we will drag down the formula with the Fill Handle tool.
Finally, in the Study Time (Second) column, we can see the converted result.
In the same way, you can convert measurements by using generic formulas according to your needs.
Download Practice Workbook
Conclusion
Here, we tried to show you 2 methods to convert measurements in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website Exceldemy to explore more.
Related Articles
- Convert Square Feet to Square Meters in Excel (2 Quick Methods)
- How to Convert Inches to Square Feet in Excel (2 Easy Methods)
- Converting CM to Inches in Excel (2 Simple Methods)
- How to Convert CM to Feet and Inches in Excel (3 Effective Ways)
- Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)
- Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)