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.

## Download Practice Workbook

## 2 Ways to Convert Measurements in Excel

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. Convert Measurements with CONVERT Function 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**numbe**r 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. Conversion of 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**numbe**r 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. Converting 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**numbe**r 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. Conversion of 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**numbe**r 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**numbe**r 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. Convert 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. Convert 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.

## 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)**