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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 1
Biweekly timesheet formula error 3
Help with formula please. 0
Multiple IF statements, macro stops at first True 0
formula auditing/evaluate formula 6
Copy addition formula of non-consecutive horizontal cells 2
Sting to VALUE conversion 3
Removing Letters and Dashes 5

Top