How to convert feet to inches, miles, and meters easily in Excel?

If you find yourself needing to convert measurements from feet to inches, miles, meters, or even centimeters in Excel, how can you do so efficiently? Converting between these units doesn't have to be time-consuming. This article outlines some clever methods to swiftly handle conversions between feet and other common units of measurement like inches, miles, and meters, facilitating your work in Excel.

• Convert feet to inches, miles, and meters with Conversion factors
• Convert feet to inches, miles, and meters with Kutools for Excel
• Convert feet to inches, miles, and meters with Convert function

Convert foot to inches, miles, and meters with Conversion factors

As we know, 1 foot = 12 inches. Therefore, we can convert the measurement unit from foot to inch by multiplying 12.

Step 1: In Cell C2 enter the formula below, and press Enter key.

=A2*12

Step 2: Click the Cell C2, and drag the   fill handle across the ranges that you will fill this formula.

You will then see all foot measurements converted to inches.

You can apply the same way to convert the feet (foot) measurement to miles and meters with conversion factors.

• 1 foot = 0.3048 meters
• 1 foot = 0.0001646 Nautical miles
• 1 foot = 0.0001894 Statute miles

Convert feet to inches, miles, and meters with Kutools for Excel

Can you convert measurement units in Excel without remembering conversion factors or functions? Yes, the Unit Conversion tool of Kutools for Excel can help you quickly convert between measurement units in Excel.

Step 1: Select a range you want to work with.

Step 2: Click the Kutools > Content > Unit Conversion. See screenshot:

Step 3: Specify the Distance unit in the drop-down box of Unit, and then select the source unit in the left box, the unit you want to convert to in the right box, and you will see the result in the Preview box. See screenshot:

Step 4: Click Ok or Apply.

You can convert feet to meters or miles using the same steps.

Convert foot to inches, miles, and meters with Convert function

It is hard to remember all of the conversion factors clearly. We can apply Excel's Convert function to change foot measurements to inches, miles, and meters. For example, we can convert foot to inches as follows:

Step 1: In Cell C2, enter the formula below, and press the Enter key.

=Convert(A2, "ft", "in")

Step 2: Click the Cell C2, and drag the  fill handle across the ranges that you will fill this formula.

Related articles:

• Convert currencies
• Convert between dollars, pounds, euros
• Unit conversions
• Convert time measurement between hour, minutes, seconds, or day