How about going metric? <g>
=CONVERT(LEFT(A1,FIND("'",A1)-1),"ft","in")+SUBSTITUTE(MID(A1,FIND("'",A1)+1
,255),"""","")
or
=(LEFT(A1,FIND("'",A1)-1)*12+SUBSTITUTE(MID(A1,FIND("'",A1)+1,255),"""",""))
the first is using a function from ATP and has to be installed or else a
name error will be the result
under format>cells>number use a custom format like
General\"
being brought up under metrics and still having to compute measurements in
my head after living
for 4 years in the US, I hope the above will work..
