Converting feet and inches to inches.

P

Peo Sjoblom

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top