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,