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.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice yourself.
3 Methods to Convert Meters to Feet in Excel
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, multiplying the measurement in meters by 3.28084 mentioned above, we can get the size in feet manually. Please follow the steps stated below.
- First, select cell D5, write down the formula as follow and hit ENTER.
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.
- Select cell D5, type down the formula as follow and press ENTER.
While putting the formula, we can see that Excel wants us to enter 3 arguments. These are number, from_unit, to_unit. This indicates to put 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.
- How to Convert MM to CM in Excel (4 Easy Methods)
- Converting CM to Inches in Excel (2 Simple Methods)
- How to Convert Inches to Square Feet in Excel (2 Easy Methods)
3. Employing Insert Function Option
We also can do the same task as above by employing the Insert Function option. Follow the necessary steps.
- At 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.
- 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 right. Now, copy the following code and paste it down into the window.
Dim x As Integer
For x = 5 To 14
Cells(x, 4).Value = Application.WorksheetFunction.Convert(Cells(x, 3).Value, "m", "ft")
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
- First, select cell D5 and type down the formula as below and press ENTER to get the result in feet and inches.
To get the feet part of our result, the formula is as below:
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 got the value in inches and again dividing by 12, we’ve got 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.
And to show the inches part the formula we used is as below:
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 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:
- Initially, select cell D5 and type down the formula as below and press ENTER to get the result in feet and inches. Use 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.
- When a number string is not valid, the CONVERT function will return the #VALUE! error.
Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website Exceldemy to explore more.