Excel

From notebook

Revision as of 07:18, 26 June 2014 by Timtak (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

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

Personal tools