Forum Discussion
Converting millimeters to feet & inches
Can someone please help me with a formula? I would like a value to be converted from mm to feet & inches. For example, if a cell has a value of 1716mm, i would like a formula to convert that numbe...
How do I convert ft and inches to just inches. Basically in my excel file height is written as "5'7" (with the apostrophe), and I have to convert it to inches. How do I do this since it's not in decimals either?
With 5'7 in A1:
=12*LEFT(A1,FIND("'",A1)-1)+MID(A1,FIND("'",A1)+1,2)
If you have Microsoft 365 you can also use
=SUMPRODUCT(TEXTSPLIT(A1,"'")*{12,1})