easy one? please respond (re:equations formatted as text in one cell, copied and calculated in anot

Posted by Daniel P on June 19, 2000 6:28 AM

I would like to have data entered into one cell
(Example: cell A1 is 120*60 or 120,60) and remain
text, then have the data multiplied in another
cell (B1 is 7200). Is this possible?

Thanks,
Daniel P.

Posted by mads on June 19, 0100 7:30 AM

If the two numbers are always separated by "*" :-

=(LEFT(A1,FIND("*",A1)-1))*(RIGHT(A1,LEN(A1)-FIND("*",A1,1)))

mads