How to Convert Measurements in Excel (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Convert Measurements in Excel

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.

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")

How to Convert Measurements in Excel

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.

How to Convert Measurements in Excel

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")

How to Convert Measurements in Excel

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.

How to Convert Measurements in Excel

Finally, we can see the converted time from minute to second in the Exercise Time (Second) column.


Similar Readings


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.

How to Convert Measurements in Excel

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.

How to Convert Measurements in Excel


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.

How to Convert Measurements in Excel

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.

How to Convert Measurements in Excel

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

Afia Kona
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo