convert feet & inches to decimals

[Roderick]

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]

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