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