How do I multiply a unit measurement?
Biff,
I finally got around to trying this and everything worked great. Thanks for
the help!!
"Biff" wrote:
Hi!
Try this:
=LEFT(A1,FIND(" ",A1)-1)*10
As long as the format is consistent: number followed by <space followed by
UM, this will work.
Biff
"Diane13" wrote in message
...
For example: 156 SQFT x $10.00. Where 156 SQFT is all in a single cell.
Is there a way to ignore the alpha characters and only look at the
numerical
characters in the formula? (Excell 2000)
Thanks,
|