Extract a country name from the different String

[amriali]

Hi,

I have Different strings with the country name in it and I need to extract the name of country from it:
1) Diamonds deposited in Kenya
2) India's gold rich is deposit
3) Natural gas deposits in Saudi

[Sean Thomas]

The only way i can see you doing this is having a range of all the countries and then looping through that range and checking if the string contains one of those country names.
That could be a very lengthy loop depending on how many countries and string to check.

Cant really help more without more data or an example workbook.

[dilipandey]

Hi amriali,

welcome to the forum.
I observed that the country names are either at beginning or at the end.. is this the case with your entire data.. confirm back so that I can provide you a formula solution. Thanks.


Regards,
DILIPandey
<click on below * if this helps>