One way:

If all your values have both feet and inches (e.g., 8 feet is 8' 0"):

=LEFT(A2,FIND("'",A2)-1)+MID(LEFT(A2,LEN(A2)-1),
FIND("'",A2)+1,255)/12

will convert the measurement to decimal.

In article ,
"ynot" wrote:

I have a column of measurments ie. 33' 8 1/2" which I need to convert to
numeric value to compute square footage. all I get as result is error. A1 =
width, A2: A40 = unique measurments.... D2:D40 = length measurments.... I
need to convert (ft) & (in) to numeric value multiply A$ by D$ = X and
convert? I think excell can do this but I'm to green to figure out? Any
help is greatly appreciated. Thank you..