# How to Convert Inches to Feet in Excel (2 Handy Ways)

When we work with measurement data, the conversion from one measurement length unit to another is a common phenomenon. In daily life, conversion from inches to feet is an important event. So, in this article, you will learn 2 handy ways to convert inches to feet in Excel.

## 2 Handy Ways to Convert Inches to Feet in Excel

Let’s first introduce our dataset. We have 7 individual and their consecutive heights in inches. Our goal is to convert these inches to feet. ### 1. Manual Approach

If you don’t want to use any function, you can use simple math calculations. As 12 inches are equal to 1 foot, we have to divide the Inches value by 12 to get the feet values.

📌 Steps:

• First, select the 1st cell under the Height (Feet) column (In this example, D5). Type the following formula into this cell.
`=C5/12` • Now, press ENTER, and drag the Fill Handle to the remaining cells. Finally, here is the converted to feet results. Read More: How to Convert Feet to Inches in Excel (4 Quick Methods)

### 2.  Convert Inches to Feet with CONVERT Function

In Excel, the CONVERT function is a simple way to convert inches to feet. To apply this function, just follow the steps below.

📌 Steps:

• Under the Height (Feet) column, select a cell (In this example, D5). Type the following formula into this cell.
`=CONVERT(C5,"in","ft")` • Press ENTER. Now, drag the Fill Handle to the remaining cells. • Here is the converted to feet heights. • Now, if you want the numbers up to the two decimal places, after all the feet values, go to the Home tab >> Number >> Format Cells icon. A format cells window will pop up. • Under the Number section, put the value 2 into the Decimal places box. Then, click on OK. Finally, here is the formatted results. ## Convert Inches to Feet & Inches

Sometimes, conversion from inches to feet and inches (For example, 66” to 5’6”) is more convenient than just inches or feet. To do this, follow the steps below.

📌 Steps:

• First, select cell D5 and copy the following formula and paste it into the cell. Then, press ENTER.
`=INT(C5/12)&"' "&MOD(C5,12)&""""` • Now, drag the Fill Handle to the remaining cells to get the height in feet and inches values. • Finally, here is the converted results. ## Conclusion  