Need help to explain this formula

E

Eug C

Anyone can explain this formula please?

=LOOKUP(99^99,--("0"&MID(C11,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C11&"0123456789")),ROW($1:$10000))))

Thanks in advance
E
 
J

James Ravenswood

The formula will return the first set of consecutive digits in a
string.
If C11 contains:
abc123r56t78
the formula will return:
123
 
Top