Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to convert centimeters (cm) to feet and inches in Excel. In this article, I am going to show you 3 essential methods in Excel to convert cm to feet and inches in Excel.
Download Practice Workbook
Download this workbook and practice while you go through this article.
3 Suitable Methods to Convert CM to Feet and Inches in Excel
This is the dataset for this method. We have some students along with their heights and will convert them from cm to feet and inches.
Now let’s concentrate on the methods.
1. Apply CONVERT Function to Convert CM to Feet and Inches
You can use the CONVERT function to convert CM to feet and CM to inches too.
1.1 CM to Feet
First, I will convert the cm using the CONVERT function.
Steps:
- Go to cell D5 and write down the following formula
=CONVERT(C5,"cm","ft")
Meanwhile, while writing this formula, Excel will show you the list of units. You can choose from them or write manually.
- Now, press ENTER. You will get the result.
- Now use the Fill Handle to AutoFill up to D11.
1.2 CM to Inches
Now, I will convert the cm to inches.
Steps:
- Go to cell D5 and write down the following formula
=CONVERT(C5,"cm","in")
- Now, press ENTER. You will get the result.
- Now use the Fill Handle to AutoFill up to D11.
Read More: Converting CM to Inches in Excel (2 Simple Methods)
Similar Readings
- Convert MM to CM in Excel (4 Easy Methods)
- How to Convert Inches to Square Feet in Excel (2 Easy Methods)
- Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)
- How to Convert Feet and Inches to Decimal in Excel (2 Easy Methods)
- Millimeter(mm) to Square Meter Formula in Excel (2 Easy Methods)
2. Convert CM to Feet and Inches Together
Now I will convert cm to feet and inches together. I will use the TRUNC, MOD, and ROUND functions to do so.
Steps:
- Go to the Cell D5 and write down the formula
=TRUNC(C5/2.54/12)&"' "&ROUND(MOD(C5/2.54,12),0)&""""
Formula Breakdown:
MOD(C5/2.54,12) ⟶ Returns the remainder after dividing (C5/2.54) by 12.
Output ⟶ 10.07874
ROUND(MOD(C5/2.54,12),0) ⟶ Round the number to a specified digit.
ROUND(10.07874,0)
Output ⟶ 10
TRUNC(C5/2.54/12) ⟶ Truncates a number to an integer.
Output ⟶ 5
TRUNC(C5/2.54/12)&”‘ “&ROUND(MOD(C5/2.54,12),0)&”””” ⟶ Returns the final output.
5&”‘ “&10&””””
Output ⟶ 5’10”
- Now press ENTER.
- Now use the Fill Handle to AutoFill up to D11.
Read More: How to Convert Decimal Feet to Feet and Inches in Excel (3 Methods)
3. Convert CM to Feet and Fraction of Inches
Now, I will convert cm in such a way that I will also get the fraction of inches along with the feet.
Steps:
- Go to the cell D5 and write down the formula
=INT(CONVERT(C5,"cm","ft")) & "' " & TEXT(12*(CONVERT(C5,"cm","ft")-INT(CONVERT(C5,"cm","ft"))),"0.00") & """"
Formula Breakdown:
INT(CONVERT(C5,”cm”,”ft”)) ⟶ Rounds the number to the nearest integer..
Output ⟶ 5
12*(CONVERT(C5,”cm”,”ft”)-INT(CONVERT(C5,”cm”,”ft”))) ⟶ Returns the output after conversion and calculation.
Output ⟶ 10.0787401574803
TEXT(12*(CONVERT(C5,”cm”,”ft”)-INT(CONVERT(C5,”cm”,”ft”))),”0.00″) ⟶ Converts the number into text with 0.00 format.
Output ⟶ “10.08”
INT(CONVERT(C5,”cm”,”ft”)) & “‘ ” & TEXT(12*(CONVERT(C5,”cm”,”ft”)-INT(CONVERT(C5,”cm”,”ft”))),”0.00″) & “”””⟶ Returns the final output.
5&”‘ “&10.08&””””
Output ⟶ 5’10.08”
- Now, press ENTER. Excel will return the output.
- Now use the Fill Handle to AutoFill up to D11.
Read More: How to Convert Inches to Feet and Inches in Excel (5 Handy Methods)
Things to Remember
While converting, one should remember the following relations.
- 1 inch = 2.54 cm
- 1 feet = 12 inches
Conclusion
In this article, I have demonstrated 3 effective methods in Excel to convert centimeters (cm) to feet and inches. I hope it helps everyone. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.
Related Articles
- How to Convert Feet to Meters in Excel (4 Simple Methods)
- Convert Meters to Miles in Excel (3 Simple Methods)
- How to Convert Meters to Feet in Excel (4 Useful Methods)
- Convert Feet to Inches in Excel (4 Quick Methods)
- How to Convert inch to mm in Excel (3 Simple Methods)
- Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
- How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)