Excel

From notebook

(Difference between revisions)
Jump to: navigation, search
(Created page with "Convert feet and inches in x'y" type notation into inches or centimetres =LEFT(H6,(FIND("'",H6)-1))*12+MID(H6,(FIND("'",H6)+1),(FIND(H$3,H6)-FIND("'",H6)-1)) Where H3 contains th...")
Line 1: Line 1:
Convert feet and inches in x'y" type notation into inches or centimetres
Convert feet and inches in x'y" type notation into inches or centimetres
-
=LEFT(H6,(FIND("'",H6)-1))*12+MID(H6,(FIND("'",H6)+1),(FIND(H$3,H6)-FIND("'",H6)-1))
+
 
-
Where H3 contains the character " because I can not escape it.
+
=LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1))

Revision as of 07:10, 26 June 2014

Convert feet and inches in x'y" type notation into inches or centimetres

=LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1))

Retrieved from "http://nihonbunka.com/wiki/index.php?title=Excel"
Personal tools