Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
Is there a way to convert "96x32x41" in one cell, from "in" to "ft" and
display the result in the next cell???? Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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. "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!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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)? "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!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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!!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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!!! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please quickly answer
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a value quickly using VBA | Excel Discussion (Misc queries) | |||
please help (need quickly) | Excel Discussion (Misc queries) | |||
need help quickly!! | Excel Discussion (Misc queries) | |||
Need help, quickly please | Setting up and Configuration of Excel | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) |