from you original post It wasn't clear that these were L*B*H dimensions so I
assumed linear so 10496 FEET 0 INCHES is correct

I'm now very confused because having established they are in fact L*B*H I'm
no nearer understanding what the answer is you want. If it's simply inches
displayed as feet then divide each by 12

=96/12 &" "& 42/12&" "& 31/12

If it's volume them multiply them tohether and divide by 1828 ( a cubic ft).
=((96*32*41)/1728)& " Cu Feet "

To have a better chance of an answer always post your own formula even if it
doesn't work.

Mike

"Ryan''s Girl" wrote:


10496FEET0INCHES

This is what it gave me. Not exactly what I was looking for.
I will have more than 500 different sizes of crates in column A

Column A-- Crate Size
96"x42"x31"
I would like Column B to Calculate Column A from inches to feet.
Then multiply column B to (number) to get a result in Column C.

End result:
I would like to have a spreedsheet of hundreds of different (LxWxH) and be
able to search a certain one in column A to find Column C result.
ha ha hope this isn't too confusing!! I'm new at excel can you tell?



"Mike H" wrote:

Try

=INT((6*32*41)/12)& " Feet " & MOD((6*32*41),12)&" Inches"

Mike

"Ryan''s Girl" wrote:

Is there a way to convert "96x32x41" in one cell, from "in" to "ft" and
display the result in the next cell????
Thanks!!!