We like to have our data both simple and gorgeous. Using too many units in a single datum makes it complicated to understand. It also looks horrible even in appearance. If we measure a distance/ height with a combination of feet and inches units, it gets troublesome for others to understand the value. It will be easy to understand if the value is described in either feet or inches units with decimal. In this article, we are going to discuss how to convert feet and inches to decimal in Excel.
For more clarifications, I am going to use a Dataset containing the Name and Height columns. Here, the heights are mentioned with a combined unit of feet and inches.
How to Convert Feet and Inches to Decimal in Excel: 2 Methods
1. Applying Arithmetic Operations to Convert Feet and Inches to Decimal
We can convert feet and inches to decimal by applying arithmetic operations. It is the simplest way for this conversion. It is easily understandable too.
Steps:
- First of all, I have modified the dataset. I have taken the combined value of feet and inches into two separate columns. The feet part of a particular value is placed in the Feet column and the inches part of that value is placed in the Inches columns.
- Then, apply the following formula with arithmetic operations in a cell to have the value in feet with decimal.
=C6+(D6/12)
Here, I input the value in cell E6. The value in D6 is in inches. So, I convert it into feet dividing the value by 12. Then, it is added to the value in cell C6 which is already in feet. Finally, I have the value in feet with decimal in cell E6 by adding these two values.
- Now, press the ENTER button.
- Finally, use Fill Handle to AutoFill the rests.
Thus, we can convert feet and inches into decimal.
Read More: How to Convert Decimal Feet to Feet and Inches in Excel
Similar Readings
- How to Convert Inches to Cm in Excel
- How to Convert Inches to Meters in Excel
- How to Convert Inches to Feet in Excel
- Millimeter(mm) to Square Meter Formula in Excel
- How to Convert MM to CM in Excel
- Converting CM to Inches in Excel
2. Using a Combined Function for Decimal Conversion
There is another effective way to convert feet and inches to decimal. We can use a formula that is a combination of LEFT, FIND, ABS, SUBSTITUTE, MID, and LEN functions.
The LEFT function returns a specified number of characters from the start of a text string.
The FIND function returns the starting position of a case-sensitive text string within another text string.
The ABS function is used to get the absolute value of a number.
The SUBSTITUTE function replaces existing text with new text in a text string.
The MID function returns a specific number of characters from the middle of a string, given a specific starting position.
The LEN function returns the number of characters in a text string.
Steps:
- Input the following formula to have the value in decimal:
=LEFT(C5,FIND("'",C5)-1)*12+ABS(SUBSTITUTE(MID(C5,FIND("'",C5)+1,LEN(C5)),"""",""))
Formula Breakdown
MID(C5,FIND(“‘”,C5)+1,LEN(C5)) – this portion provides the value from the double quotes.
Output – “-9 1/10″””
SUBSTITUTE(MID(C5,FIND(“‘”,C5)+1,LEN(C5)),””””,””) – becomes SUBSTITUTE(“-9 1/10″””,””””,””) and will replace the multiple quotes with a couple of one.
Output – “-9 1/10”
ABS(SUBSTITUTE(MID(C5,FIND(“‘”,C5)+1,LEN(C5)),””””,””)) – becomes
ABS(“-9 1/10”) – converts the text into positive number
Output – 9.1
LEFT(C5,FIND(“‘”,C5)-1)*12 – provides the value before the quotes and multiplies the value with 12
Output – 72
LEFT(C5,FIND(“‘”,C5)-1)*12+ABS(SUBSTITUTE(MID(C5,FIND(“‘”,C5)+1,LEN(C5)),””””,””)) – becomes 72 + 9.1 and provides the final output
Output – 81.1
- Hit ENTER.
- Finally, AutoFill the rest.
Read More: How to Convert Inches to Feet and Inches in Excel
Similar Readings
- How to Convert Square Feet to Square Meters in Excel
- Convert Cubic Feet to Cubic Meters in Excel
- How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel
- How to Convert CM to Feet and Inches in Excel
- How to Convert Lbs to Kg in Excel
- How to Convert Kg to Lbs in Excel
Practice Section
For more expertise, you can practice here.
Download Practice Workbook
Conclusion
In this article, I have tried to articulate the whole process of how to convert feet and inches to decimal in Excel. I hope it will be helpful for all. For any further questions, comment below.
Related Articles
- How to Convert Feet to Meters in Excel
- How to Convert Meters to Miles in Excel
- How to Convert Meters to Feet in Excel
- How to Convert Feet to Inches in Excel
- How to Convert inch to mm in Excel
- How to Convert Millimeters (mm) to Inches (in) in Excel
- How to Convert Inches to Square Feet in Excel
- How to Convert Radians to Degrees in Excel
Thank you so so much!