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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Convert Inches to Feet in Excel: 2 Ways

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.

2 Handy ways to Convert Inches to Feet in Excel


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 Inch 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

Manual Approach

  • Now, press ENTER, and drag the Fill Handle to the remaining cells.

Manual Approach

Finally, here are the converted to feet results.

Read More: How to Convert Feet to Inches in Excel


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

Convert Inches to Feet with CONVERT Function

  • Press ENTER. Now, drag the Fill Handle to the remaining cells.

Convert Inches to Feet with CONVERT Function

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

Convert Inches to Feet with CONVERT Function

  • 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 with CONVERT Function

Read More: How to Convert Feet and Inches to Decimal in Excel


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

Convert Inches to Feet & Inches

  • Now, drag the Fill Handle to the remaining cells to get the height in feet and inches values.

Convert Inches to Feet & Inches

  • Finally, here are the converted results.

Convert Inches to Feet & Inches


Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article.


Conclusion

In this tutorial, I have discussed 2 handy ways to convert inches to feet in Excel. I hope you found this article helpful. Drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

  1. How to Convert inch to mm in Excel
  2. How to Convert Inches to Cm in Excel
  3. How to Convert Inches to Meters in Excel
  4. How to Convert Inches to Square Feet in Excel
  5. How to Convert Decimal Feet to Feet and Inches in Excel
  6. How to Convert Millimeters (mm) to Inches (in) in Excel
  7. How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hafiz Islam
Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo