to extract numeric figures in left side od the alpha charectors pl

[pol]

Hai all



I have an excel sheet with the following structure



Code



123445PPSS4

4567ITEM

23444MALR

234555HJYT45



IN THE ABOVE EXAMPLE PLEASE HELP TO EXTRACT NUMERIC FIGURES FROM THE LEFT
SIDE OF THE TEXT



THE RESULT SHOULD BE



12344

4567

23444

234555



PLEASE HELP



WITH THANKS AND REGARDS

POL

 

[Mike H]

Try

=LOOKUP(6.022*10^23,--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW(INDIRECT("1:"&LEN(A2)))))

Mike