=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.