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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - to extract numeric figures in left side od the alpha charectors pl (https://www.excelbanter.com/excel-discussion-misc-queries/199462-extract-numeric-figures-left-side-od-alpha-charectors-pl.html)

pol

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

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

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

Try

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

Mike

"pol" wrote:

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

All times are GMT +1. The time now is 02:50 AM.