Hmmm, not sure if this is what you need, but assuming this input:
96"x42"x31"

This is column B (rounded up to nearest 100th of a foot)
=ROUNDUP(LEFT(A6,FIND(CHAR(34),A6)-1)/
12,2)&"'x"&ROUNDUP(MID(A6,FIND("x",A6)+1,FIND(CHAR (34),A6,FIND("x",A6))-
FIND("x",A6)-1)/
12,2)&"'x"&ROUNDUP(MID(A6,FIND("x",A6,FIND(CHAR(34 ),A6,FIND("x",A6)))
+1,2)/12,2)&"'"

This is column C, using the rounded values:
=ROUNDUP(LEFT(A6,FIND(CHAR(34),A6)-1)/
12,2)*ROUNDUP(MID(A6,FIND("x",A6)+1,FIND(CHAR(34), A6,FIND("x",A6))-
FIND("x",A6)-1)/
12,2)*ROUNDUP(MID(A6,FIND("x",A6,FIND(CHAR(34),A6, FIND("x",A6)))+1,2)/
12,2)&" cu ft"

On Aug 16, 8:50 pm, 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!!!- Hide quoted text -

- Show quoted text -