=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" wrote in message
...
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
|