How to Convert Meters to Feet in Excel (4 Useful Methods)

If you want to convert meter to feet or meter to feet and inches in Excel, you are in the right place. This article is for you. Here we will take you through 4 easy and convenient methods on how to convert meters to feet in Excel. Moreover, you get 2 extra methods for converting meters to feet and inches in Excel as well.

How to Convert Meters to Feet in Excel: 4 Methods

Unit conversion in Excel is a procedure that is very common and easy. We’ve got a dataset of 10 land Owners and their corresponding Cable Lengths in meters to set up broadband internet connections in their houses.

Here, we’ll show a handful of different methods of converting meters to feet. So let’s go through them one by one.

1. Converting Meter to Feet Manually

As we all know, 1 meter is equal to 3.28084 feet for exact. As a result, by multiplying the measurement in meters by 3.28084 mentioned above, we can get the size in feet manually. Please follow the steps stated below.

Steps:

First, select cell D5, write down the formula as follows, and hit ENTER.

=C5*3.28084

Here, we’ve multiplied the value of cell C5 by 3.28084 to get the measurement in feet in cell D5.

Then use the Fill Handle tool and drag it down to cell D14 to get the other cell’s value in feet.

2. Using CONVERT Function to Convert Meters to Feet in Excel

Excel’s built-in CONVERT function makes unit conversion simple. It uses only 3 arguments and provides a wide range of unit conversions. We’re transforming meters to feet using the CONVERT function now.

Steps:

Select cell D5, type down the formula as follows and press ENTER.

=CONVERT(C5,"m","ft")

While putting the formula, we can see that Excel wants us to enter 3 arguments. These are number, from_unit, to_unit. This indicates the number we want to convert and the units between which we wanna make the conversion.

Now, utilizing the Fill Handle tool get further values of the cells below.

3. Employing Insert Function Option

We also can do the same task as above by employing the Insert Function option. Follow the necessary steps.

Steps:

First, select cell D5 and click on the Insert Function symbol just beside the formula bar. You can see an Insert Function pop-up dialog box. In the Search for a function box write “convert” and click on Go. Then, from the Select a function option, select CONVERT and click on OK or hit the ENTER button.

At this moment, we have a Function Arguments dialog box where we’ve to input the necessary arguments of the CONVERT function. In Number, From_unit, To_unit option write down C5, “m” and “ft” sequentially. Then click on OK or press ENTER.

Finally, we can see that our result shows in cell D5, and from the Formula Bar we can be assured that it’s the same formula that we used in our previous method.

4. Applying VBA Code to Convert Meters to Feet

Conversion applying VBA is also a simple and nice process. Just follow along with us.

Steps:

First, go to the respective sheet of VBA. Then, right-click on the sheet name and select View Code.

Then, from Toggle Folders, select the respective sheet of our VBA code, right-click on it, and select Insert > Module.

Instantly, a window appears on the right. Now, copy the following code and paste it down into the window.

Sub Convert_VBA() Dim x As Integer For x = 5 To 14 Cells(x, 4).Value = Application.WorksheetFunction.Convert(Cells(x, 3).Value, "m", "ft") Next x End Sub

Lastly, select Run from the top ribbon and then close the window. Finally, you can see the meters converted into feet in column D.

Convert Meter to Feet and Inches in Excel

As sometimes it’s very convenient to show the result in feet and inches format rather than just only in feet. So, here we’re giving 2 methods to convert meters to feet and inches in Excel.

1. Implementing TRUNC, MOD, and ROUND Function

Luckily, you can use a formula based on the TRUNC, MOD, and ROUND functions to convert a measurement in meters to feet and inches. Follow the steps carefully.

Steps:

First, select cell D5 and type down the formula below, and press ENTER to get the result in feet and inches.

=TRUNC(C5*100/2.54/12)&"' "&ROUND(MOD(C5*100/2.54,12),0)&""""

Formula Breakdown:

To get the feet part of our result, the formula is as below:

=TRUNC(C5*100/2.54/12)&"' "

Here, we’ve multiplied the value of cell C5 by 100. By doing this we’re converting it from the meter into cm. Then divide it by 2.54, we get the value in inches, and again dividing by 12, we get the value in feet. Now, we are using the TRUNC function to get the integer part without taking the decimal part into consideration. Also, a single quote sign is concatenated with an ampersand (&) operator to show the feet (‘) sign.

To show the inches part the formula we used is as below:

&ROUND(MOD(C5*100/2.54,12),0)&""""

We multiplied the value of cell C5 by 100 to get the measurement in cm, then divided it by 2.54 to get it in inches. Now, we’ve used the MOD function to get the remainder after dividing it by 12. Also, we got the help of the ROUND function to show our inches part in an integer by rounding up the decimal portion up to 0 digits.

2. Engaging INT, TEXT, and MOD Function with CONVERT Function

In this method, we applied a formula combining INT, TEXT, and MOD functions with the CONVERT function. The steps are as below:

Steps:

Initially, select cell D5 and type down the formula below, and press ENTER to get the result in feet and inches. Use the Fill Handle to complete the table.

=INT(CONVERT(C5,"m","ft")) & " ft. " &TEXT(MOD(CONVERT(C5,"m","in"), 12), "0 ""in.""")

Things to Remember

The CONVERT function is case-sensitive.

Here, it is clearly noticeable that in the formula we’ve entered “M” instead of “m”. So the function isn’t working and returned a N/A error.

When a unit string is not recognized, the CONVERT function will return the #N/A error.
When a unit conversion isn’t physible, the CONVERT function will return the #N/A error.