Excel

(Difference between revisions)

Latest revision as of 07:18, 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))

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

Revision as of 07:10, 26 June 2014 (view source) Timtak (Talk \| contribs) ← Older edit		Latest revision as of 07:18, 26 June 2014 (view source) Timtak (Talk \| contribs)
Line 2:		Line 2:

	=LEFT(H5,(FIND("'",H5)-1))*12+MID(H5,(FIND("'",H5)+1),(FIND("""",H5)-FIND("'",H5)-1))		=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)))