How do I multiply a unit measurement?

[Guest]

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,

 

[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

 

[Guest]

Thank You! I'll try it tomorrow.

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

 

[Guest]

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