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
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