R Roderick Jul 22, 2008 #1 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
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
T Teethless mama Jul 22, 2008 #2 =LEFT(A1,FIND("-",A1)-2)+SUBSTITUTE(MID(A1,FIND("-",A1)+1,5),"""","")/12
