Hi! Already found a partial solution to my problem from this board - I need to extract 8-digit number from a text string. Quite like discussed in another thread (unfortunately can't post a link "Finding numbers in text string").
Option provided there by daddylonglegs partially matches my needs:

=TEXT(LOOKUP(10^8,MID(SUBSTITUTE(A1," ","x");ROW(INDIRECT("1:"&LEN(A1)-7)),8)+0),"00000000")
However this formula processes the string starting from the back (from right to left), but I'd need it to work left-to-right. So from a string of "Data 10569228 AND 11112365 00671990000105729657 String continuing"
I'd need to grab "10569228", however this formula currently grabs "05729657"

Could you please help me out? I'm having a hard time understanding this one. If it was able to ignore non-8 digit numbers, even better, but that's less important. Thanks a lot!