NON-VBA: FORMULA NEEDED - Looping through string and stop on non-numeric

Originally Posted by XOR LX

Hi,

=MID(A1,1,6+MATCH(FALSE,INDEX(ISNUMBER(0+MID(A1,7+ROW($1:$999),1)),,),0))

Regards

Thanks XOR LX! Reps up to you!

I still don't understand the formula how it works :'(