You can use the following formula to convert feet and inches into a decimal in Excel:

=TEXTBEFORE(A2,"'")+TEXTBEFORE(TEXTAFTER(A2,"'"),"""")/12

This will convert the feet and inches in cell A2 into a decimal.

For example, if cell A2 contains 6’5″ then this formula will convert this into 6.4167.

The following example shows how to use this formula in practice.

Example: Convert Feet and Inches to Decimal in Excel

Suppose we have the following dataset in Excel that shows the height of various athletes:

To convert each height from feet and inches into a decimal, we can type the following formula into cell B2:

=TEXTBEFORE(A2,"'")+TEXTBEFORE(TEXTAFTER(A2,"'"),"""")/12

We can then drag and fill this formula down to each remaining cell in column B:

Column B now displays the feet and inches in column A as a decimal.

For example:

• 6 feet and 2 inches is equal to 6.1667 feet.
• 6 feet and 5 inches is equal to 6.4167 feet.
• 5 feet and 10 inches is equal to 5.8333 feet.

And so on.

How This Formula Works

=TEXTBEFORE(A2,"'")+TEXTBEFORE(TEXTAFTER(A2,"'"),"""")/12

Here is how this formula works:

First, we use TEXTBEFORE(A2, “‘”) to extract the text before the first single quote in cell A2.

This extracts the value 6.

Next, we use TEXTBEFORE(TEXTAFTER(A2,”‘”),””””)/12 to extract the text between the single quote and the double quote and divide it by 12.

This results in 2 / 12 = 0.1667.

Lastly, we use a plus sign ( + ) to add these two values.

This results in 6 + 0.1667 = 6.1667.

The following tutorials explain how to perform other common operations in Excel: