Formula to ignore numbers and capture country name

[Mr.Karr]

Hello

Can anyone please provide a formula to capture country names that appear before the numbers.

WE HQ 20150317154643.xlsx
UK 20150318130214.xlsx
UK 20150317142505.xlsx
UK 20150317130000.xlsx
UK 20150317125952.xlsx
UK 20150317125726.xlsx
UK 20150317122350.xlsx
UK 20150317115516.xlsx
UK 20150316133056.xlsx
UK 20150316091003.xlsx
UK 20150313162155.xlsx
UK 20150312194150.xlsx
Turkey 20150317173402.xlsx
Turkey 20150317165643.xlsx
Thailand 20150318115537.xlsx
Thailand 20150318080619.xlsx

fyi, 201* would be by default. and before that a space should be ignored. Capture only the country name. Appreciate your help.

Many thanks in advance
Karthik

 

[Somendra Misra]

Hi Karthik,

Considering data in A1 try below formula.

=LEFT(A1,FIND(" ",A1)-1)

OR

=LEFT(A1,SEARCH("201*",A1)-1)

Regards,

 

[Mr.Karr]

thanks SM @Somendra Misra. It works like a breeze!

 

[Somendra Misra]

Welcome Back Karthik!!!

Regards,