convert feet & inches to decimals

Roderick · Jul 22, 2008

example: I need to insert 3'-2" into one cell and the result shown in another
cell would be the equivalent in decimals of feet

Teethless mama · Jul 22, 2008

=LEFT(A1,FIND("-",A1)-2)+SUBSTITUTE(MID(A1,FIND("-",A1)+1,5),"""","")/12