Excel
From notebook
(Difference between revisions)
Timtak (Talk | contribs)
(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...")
Newer edit →
(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...")
Newer edit →
Revision as of 07:09, 26 June 2014
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.
