How to find number in a string and extract number to new column

[jk51]

Hi,

Help please on how to write formula to find number in a string after "Lon" and extract number to new column?

For example

First column: A1="Lon5_0_1i_F.jpg"
Second column i want the output B1 = "5"

First column: A2="Lon13_0_1i_M.jpg"
Second column i want the output B1 = "13"

First column: A2="Lon126_0_1i_F.jpg"
Second column i want the output B1 = "126"

Thank you.

Bw

Mr Singh

 

[chirayu]

Sample file attached

 

[jk51]

Thanks Chirayu. It's all working. Excellent.

Bw

Mr Singh

 

[bosco_yip]

Or,

In B1, copy down :

=0+MID(A1,4,FIND("_",A1)-4)

Regards