The values that you have are currently stored as text. As such ther is no
direct way to calculate the totals as you have requested. So Yes you need to
split the cells out into their component measurements.
--
HTH...

Jim Thomlinson


"Kimberlie" wrote:

I have four columns in my Excel 2007 worksheet that I need help resolving. Is
it
possible to for excel to accomplish the following:

First Column, "I" (in x in = SQ FT)
In cell I:206 I have the equation exactly as; 030'' x 048'' Can excel
calculate and put the answer 10 in J:206?

Second Column, "M" (mm x mm = M2)
In cell M:205 I have the equation exactly as; 0406 x 0889 Can excel
calculate and put the answer .36 in J:206?

Third Column, "Q" (in x in x Ft = FBM)
In cell Q:18 I have the equation exactly as; 06'' x 08'' x 16' Can excel
calculate and put the answer 5.3 in R:18?


Fourth Column, "U" (mm x mm x m =M3)
In cell U:28 I have the equation exactly as; 191 x 191 x 4.9 Can excel
calculate and put the answer .04 in V:28?

Or, is de-concatenate necessary first to arrive at the calculations?

Thank you in advance for your help.


--
Kimberlie