Bob didn't really mean that.
What he really wanted to say was :

=MID(A1,FIND("8",A1),7)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
=MID(A1,Find("8",A1),8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Send Object Command - Two attachments"
soft.com wrote in
message
...
How can I extraxt a string that begins with a certain number and is only
X
amount of digits long?
Example: I need to extract where an "8" is found, and the next 6 spaces
that
immediately follow:

fgte8575684vrdef - Resut should be 8575684

Any ideas? Thanks.