I have many excel field witch contains ft and inches example: 5' 10".

How to i convert it to meters assuming the feet and inches value is on A1.

iv tried to backtrack this formula with no success

`=INT(CONVERT(A1,"mm","ft")) & " '" &  12*(CONVERT(A1,"mm","ft")-INT(CONVERT(A1,"mm","f` Feb 22 in Database 152 views

## 1 answer to this question.

There are certain direct formulas to convert inches to millimeters in excel

You'll have to use it directly in Excel

for converting inches to millimeter  -  =CONVERT(A2,"in","mm")
for converting inches to centimeter -  =CONVERT(A2,"in","cm")

And in excel sheet  u can find an option KUTOOL>CONTENT>UNIT conversion option
thereafter selecting unit conversion, select the unit category from Units drop-down list, and specify the units you want to convert between two lists if you want to display the result in a comment, check to Add results as a comment
select ok and now you can see the converted values answered Feb 23 by
• 13,560 points

## How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

need the row/column combinations marked with an ...READ MORE

## EXCEL How to check if Column A contains specific value and Column B contains 2 specific values?

If you're looking for the string CHECK in cells ...READ MORE

## How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert JSON file to Excel File

Hi To convert a file, Set options and ...READ MORE