0 votes

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, 2022 in Database 1,459 views

## 1 answer to this question.

0 votes

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, 2022 by
• 23,260 points

0 votes
0 answers

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

0 votes
1 answer

## How to read and write excel file

When broken down into steps, reading an ...READ MORE

0 votes
1 answer

## How to read and write excel file

When broken down into steps, reading an ...READ MORE

0 votes
1 answer

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

0 votes
1 answer

## Find the serial number with criteria

Use the filter function: =FILTER(\$C\$11:\$C\$39;(\$H\$11:\$H\$39=MAXIFS(\$H\$11:\$H\$39;\$N\$11:\$N\$39;4))*(\$N\$11:\$N\$39=4)) Maybe you have to ...READ MORE

0 votes
1 answer

## Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

0 votes
1 answer

## Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

0 votes
0 answers

## What is function in MS Excel?

What is function in MS Excel? READ MORE

0 votes
1 answer

## Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell

Select the row or column that you ...READ MORE

0 votes
1 answer

## Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE