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.
