How do I multiply a unit measurement?
 

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,

How do I multiply a unit measurement?
 

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,

How do I multiply a unit measurement?
 

Thank You! I'll try it tomorrow.

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

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,