Excel

From notebook

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