How do I multiply a unit measurement?

D

Diane13

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,
 
B

Biff

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
 
D

Diane13

Thank You! I'll try it tomorrow.

Biff said:
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
Click to expand...
 
D

Diane13

Biff,
I finally got around to trying this and everything worked great. Thanks for
the help!!
 
Top