The function that is intended for this sort of thing (i.e. you know where the
text begins (2nd char) and how long it is (2 chars) is MID.
=--MID(D4,2,2)
On Thu, 17 Feb 2005 09:55:09 -0500, "Stan Altshuller"
wrote:
it works!
how would one know that? I can not find help on this -- function. amazing
:) anyway THANKS for replying so quickly.
Stan
"Bob Phillips" wrote in message
...
Hi Stan,
One way
=--RIGHT(D4,2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|