Extract the data

[guna_sekar87]

kindly give a code or macro to extract 6 digit number which stats with "22"(inclusive)

 

[Xiq]

Hi guna_sekar87,

See attached file.

 

[json]

if it doesnt have to be code you could do this with the LEFT or MID functions..depending where the '22' was located.

if the 6 digit number is inside a string, then you'd need to use MID. if the 6 digit number is only 6 characters long, and you're only wanting the ones that start with '22', you could use the LEFT function (nested with IF).

 

[Hui]

Using Json idea above
In Z2: =IFERROR(MID([@Alors],FIND("22",[@Alors]),6),"not found")

or =IFERROR(MID([@Alors],FIND("22",[@Alors]),6),0)

 

[Somendra Misra]

Another formula,

=IFERROR(MID([@Alors],SEARCH("22",[@Alors],1),6),"")

I liked your data, I think its IC engine testing data.

Regards!