How to Convert Measurements in Excel (2 Quick Ways)

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:

• 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.

• 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.

• 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.

• 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.

• 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.

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.

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)