Please quickly answer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to convert "96x32x41" in one cell, from "in" to "ft" and
display the result in the next cell????
Thanks!!!
 
what you have in the column- 96"x42"x31" is a text string. You need to be
able to pick out the number parts, convert to values, divide by 12 to get
feet, convert back to text to display in the next cell. The hard part in all
that is picking out the numbers. If they are all always 2 digits, then it's
easy, the are always in the same place and you can use the =MID() function to
pick them out. If they are different, you need VB code to go through and
parse it.
 
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?
 
Is the data in column A literally a text string as you post:

96"x42"x31" (with the " quotes and lower case x as multiplier)?

And when you say you multiply column B (a volume) by a number then column C
will also require some further arithmetic to convert ft/ins * number.

Column C is the total volume of N crates where is unspecified (your number)?
 
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
 
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"
 
Back
Top