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.


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

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