Try...

=IF(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01 23456789")),1)+0=8,MID(
A1,FIND(8,A1),7),"")

Hope this helps!

In article ,
"Send Object Command - Two attachments"
soft.com wrote:

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.