Need help!

[Kimberlie]

I have four columns in my 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.

 

[Dave]

Hi Kimberlie,
One of the MVP's may disagree with me, but I think you have some work ahead
of you. I would use EDIT, REPLACE to change all the x's for nothing, then do
it again to replace all the " with nothing, and do it again for any other
extraneous symbols you have in the cells. Once you just have numbers and
spaces, you can use Text to Columns to de-concatenate (parse) the data. From
there you can perform the maths you want.
Sorry I can't be more helpful
Regards - Dave.

 

[Pete_UK]

With those particular entries, put these formulae in the cells stated:

J206: =LEFT(I206,3)*MID(I206,9,3)/144

N205: =ROUND(LEFT(M205,4)*RIGHT(M205,4)/1000000,2)

R18: =ROUND(LEFT(Q18,2)*MID(Q18,8,2)*MID(Q18,15,2)/144,1)

V28: =ROUND(LEFT(U28,3)*MID(U28,7,3)*MID(U28,13,3)/1000000,2)

Here's what I got:

J206 = 10, N205 = 0.36, R18 = 5.3, V28 = 0.18.

The last one differs from your example, but does check out with a
calculator.

Hope this helps.

Pete