> =N(right(left(D64,3),2))

Instead of using Right & Left, using Mid might be an option:

The following would return 30 from "Q30 no lockup"

=VALUE(MID(A1,2,2))
or:
=--(MID(A1,2,2))

HTH
--
Dana DeLouis
Win XP & Office 2003

"Stan Altshuller" <ctaca@hotmail.com> wrote in message
news:ucL4j5PFFHA.3384@tk2msftngp13.phx.gbl...
> Hi All!
>
>
> How do I extract a number from a string? Example:
> cell D64 has a string "Q30 no lockup" in my case, the first char is
> always
> a letter and the next two chars form a number I need to extract.
> When I try
> =N(right(left(D64,3),2)) it returns 0 I need 30. I need ultimately to
> find
> the average of these numbers in the strings running across.
> Help?
>
> THANKS!
> Stan
>
>
>