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

If you want to convert meters to feet or meters to feet and inches in Excel, you've come to the right place. This article is for you. Here we will guide you through 4 easy and convenient methods on how to convert meters to feet in Excel. In addition, you will get 2 additional methods to convert meters to feet and inches in Excel.

Download exercise book

You can download the following Excel workbook for better understanding and practice by yourself.

3 Methods to Convert Meters to Feet in Excel

unit conversionin Excel is a procedure that is very common and simple. We have a record of 10 propertiesOwnerand their correspondingcable lengthsin meters to set up broadband Internet connections in their homes.

Here we show a handful of different methods to convert meters to feet. So let's go through them one by one.

1. Convert meters to feet manually

As we all know, 1 meter is exactly 3.28084 feet. As a result, we can multiply the measurement in meters mentioned above by 3.28084Get the height in feetmanually. Please follow the steps below.

Steps:

• First select a cellD5, write the formula as follows and pressENTER.

Here we have multiplied the value of cellC5through3.28084to get the measurement in feet inside the cellD5.

• Then use thefill handletool and drag it down into the cellF14to get the value of the other cell in feet.

Continue reading:How to Convert Feet to Meters in Excel (4 Easy Methods)

2. Using CONVERT function to convert meters to feet in Excel

Excel is integratedCONVERT functionmakes unityconversioneasy. It only takes 3 arguments and offers a wide range of unit conversions. We convert meters to feet using thatCONVERTwork now.

Steps:

• select cellD5, enter the formula as follows and pressENTER.

When pasting the formula, we can see that Excel wants us to enter 3 arguments. These areNumber,from_unit,to_unit. This indicates that we need to enter the number we want to convert and the units we want to convert between.

• Now use thefill handletool to retrieve further values ​​of the underlying cells.

Continue reading:How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)

Similar readings

• How to Convert MM to CM in Excel (4 Easy Methods)
• Convert CM to Inches in Excel (2 Easy Methods)
• How to Convert Inches to Square Feet in Excel (2 Easy Methods)

3. Using the Insert Function option

We can also perform the same task as above using theinsert functionPossibility. Follow the required steps.

Steps:

• First select a cellD5and click theinsert functionicon right next to the formula bar. You can see oneinsert functionpop-up dialog box. In whichSearch for a functionWrite in the “Convert” box and clickwalk. Then from theChoose a functionoption, selectCONVERTand clickOKor beat themENTERTaste.

• At this moment we have onefunction argumentsDialog box in which we must enter the required arguments of theCONVERTFunction. in theNumber,from_unit,To_unitWrite down option C5, “m” and “ft” one after the other. Then clickOKor pressENTER.

• Finally we can see our result is displayed in the cellD5and from theformulatableWe can be sure that it is the same formula that we used in our previous method.

Continue reading:Convert Cubic Feet to Cubic Meters in Excel (2 Easy Methods)

4. Applying VBA code to convert meters to feet

conversion appliesVBAis also a simple and beautiful process. Just follow us.

Steps:

• First go to the respective sheet ofVBA. Then right click on the sheet name and selectshow code.

• Then offswitch folders, choose the appropriate sheet of ourVBACode, right click on it and selectinsertion>Module.

• A window will immediately appear on the right. Now copy and paste the code below into the window.

Sub Convert_VBA()
Dim x as an integer
For x = 5 to 14
Cells(x, 4).Value = Application.WorksheetFunction.Convert(Cells(x, 3).Value, "m", "ft")
next x
End Sub

Select lastTo runfrom the top ribbon and then close the window. Finally, you can see the meters converted to feetColumn D.

Continue reading:How to Convert Meters to Miles in Excel (3 Easy Methods)

Convert meters to feet and inches in Excel

Sometimes it's very useful to show thatResult in feet and inchesformat and not just in feet. So, here we give 2 methods to convert meters to feet and inches in Excel.

1. Implementing TRUNC, MOD and ROUND function

Fortunately, you can use a formula based on thatPROBOSE,MOD, andROUNDFunctions to convert a measurement in meters to feet and inches. Follow the steps carefully.

Steps:

• First select a cellD5and enter the formula as below and pressENTERto get the result in feet and inches.

Formula breakdown:

To get the footer part of our result, the formula is as follows:

Here we have multiplied the value of cellC5divided by 100. This converts it from meters to cm. Then divide it by 2.54, we get the value in inches, and divided again by 12, we get the value in feet. Now let's use thosePROBOSEFunction to get the integer part without theDecimalpart under consideration. Also, a single quote is concatenated with aampersand(&) operator to display the footer (‘).

And to show the inch part, we used the formula as follows:

We have multiplied the value of cellC5by 100 to get the measurement in cm and then divide by 2.54 to get it in inches. Now we used thatMODFunction to get the remainder after dividing by 12. Also, we got help fromROUNDFunction to display our inch part as an integer by rounding the decimal part up to 0 digits.

Continue reading: How to Convert CM to Feet and Inches in Excel (3 Effective Ways)

2. Enabling the INT, TEXT, and MOD function with the CONVERT function

In this method, we used a combination of formulasINT,TEXT, andMODworks with theCONVERTFunction. The steps are as follows:

Steps:

• First select a cellD5and enter the formula as below and pressENTERto get the result in feet and inches. Use Fill Handle to complete the table.

things to remember

• ThatCONVERTThe function is case-sensitive.

It is obvious here that we entered “M” instead of “m” in the formula. So the function doesn't work and returned aN / AError.

• If a unit string is not recognized, theCONVERTfunction returns the#N / AError.
• If a unit conversion is not possible, theCONVERTfunction returns the#N / AError.

• If a sequence of numbers is invalid, theCONVERTfunction returns the#WERT!Error.

Conclusion

Thank you for reading this article. We hope it was helpful. If you have any questions or suggestions, please let us know in the comment section. Please visit our websiteExceldemymore to explore.

Related Articles

• Convert Feet to Inches in Excel (4 Quick Methods)
• How to Convert Inches to mm in Excel (3 Easy Methods)
• Convert Kg to Lbs in Excel (4 Easy Methods)
• How to Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)
• Millimeters (mm) to Square Meters Formula in Excel (2 Easy Methods)