Excel

From notebook

Revision as of 07:10, 26 June 2014 by Timtak (Talk | contribs)
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))

Personal tools