How do I multiply a unit measurement?

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

[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

"Diane13" <[email protected]> wrote in message
news:[email protected]...
> 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,

[Diane13]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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,
>
>
>

[Diane13]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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,
>
>
>