Data Processing

[workrelated]

Hi,

I need some idea to process a set of data, which only first 2 numbers in a cell are needed. Example as table below,

Data	Expected Output
YL28T709 <tbody> </tbody>	28
32SH <tbody> </tbody>	32
LED2410 <tbody> </tbody>	24
L32FNT <tbody> </tbody>	32
OLED55C7T <tbody> </tbody>	55

<tbody>
</tbody>

It will be great if there is any formula which could process the data in a efficient way, because i have at least 10k of row to be processed.

THanks

 

[Marcelo Branco]

Welcome to Mr Excel

Maybe...

Formula in B2 copied down
=--MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),2)

Hope this helps

M.