# 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.

3 Methods to Convert Meters to Feet in Excel

1. Convert meters to feet manually

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

3. Using the Insert Function option

4. Applying VBA code to convert meters to feet

Convert meters to feet and inches in Excel

1. Implementing TRUNC, MOD and ROUND function

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

things to remember

Conclusion

Related Articles

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

Converting Meters to Feet.xlsm

## 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.

`=C5*3,28084`

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.

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

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)

• 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 integerFor x = 5 to 14Cells(x, 4).Value = Application.WorksheetFunction.Convert(Cells(x, 3).Value, "m", "ft")next xEnd 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.

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

Formula breakdown:

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

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

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:

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

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.

`=INT(CONVERT(C5,"m","ft")) & " ft. " &TEXT(MOD(CONVERT(C5,"m","in"), 12), "0 ""in.""" )` ## 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. ## 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)
Top Articles
Latest Posts
Article information

Author: Edwin Metz

Last Updated: 01/02/2023

Views: 6148

Rating: 4.8 / 5 (58 voted)

Author information

Name: Edwin Metz

Birthday: 1997-04-16

Address: 51593 Leanne Light, Kuphalmouth, DE 50012-5183

Phone: +639107620957

Job: Corporate Banking Technician

Hobby: Reading, scrapbook, role-playing games, Fishing, Fishing, Scuba diving, Beekeeping

Introduction: My name is Edwin Metz, I am a fair, energetic, helpful, brave, outstanding, nice, helpful person who loves writing and wants to share my knowledge and understanding with you.