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,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Data[/TD]
[TD]Expected Output[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]YL28T709[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]32SH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]LED2410[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]L32FNT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]OLED55C7T[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]55[/TD]
[/TR]
</tbody>[/TABLE]

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.