Converting units can be time consuming when you rely on a separate tool or website to do it. In this guide, we are going to show you how to convert inches to feet and inches to feet in Excel.
The first approach we are going to show you is doing the conversion manually. You can convert inches to feet using a simple math operation. 1 foot is equal to 12 inches. Thus, you need to divide the inch-value by 12 to get the value in feet.
Let's say the cell C2 contains the inch-value. Use the formula below to find the result in feet.
Similarly, you can convert feet to inches by manually calculating the other way around. As in the example above, multiplying a feet value by 12 returns the value in inches. If we assume that the cell C5 contains the feet value, the conversion formula would be as below.
Let's now take a look at how to convert units automatically in Excel.
Using CONVERT Function to convert inches to feet, and vice versa
Another way to convert inches to feet is using the CONVERT function. The CONVERT function can convert a number from one measurement system to another. The best part is that the function is not limited to only feet and inch units only. You can convert weight, distance, temperature, and more units of measurements between each other.
Briefly, you need to enter both the value and measurement types into the function. Excel accepts string abbreviations of the measurement types. In this example you can use,
- Foot: "ft"
- Inch: "in"
As a result, to convert the value in cell B5, you need to use a formula like below:
To make the conversion in the opposite direction, simply switch the measurement arguments. The following formula converts the value from feet to inches.