Microsoft Office Tutorials and References

In Depth Information

**Converting Inches to Feet and Inches**

Converting Inches to Feet and Inches

If you ever need to convert inches to feet and inches, you’ll quickly understand the merits of the

metric system. Converting inches to feet and inches is basically a division problem, in which you

need to pay attention to the remainder (leftover inches).

The following formula assumes that cell A2 contains a value that represents inches. The formula

displays the result in feet and inches (for example, if A2 contains 43, the result is 3'7"):

=TEXT(INT(A2/12),”#,##0”)&”’ “&MOD(A2,12)&””””

This formula returns a text string, so you can’t perform mathematical operations on the result. If

you want to convert a feet-and-inches text string back to inches, this formula does the job (it

assumes that cell A1 contains a string such as 9'11"):

=(LEFT(B2,FIND(“’”,B2)-1)+((MID(B2,FIND(“’”,B2)+1,LEN(B2)-

FIND(“’”,B2)-1))/12))*12

These formulas work with positive inches only.

Figure 99-1 shows these formulas in use.

Figure 99-1:
Converting inches to feet and inches and then back to inches.