Hi,
Can someone guide with a formula, just want to identify name of a country present in a line in a cell, for eg there is an address "1023 building road, street kingkong, Nepal" i have thousands lines like these in a column, need a formula which should give return value as "Nepal" since its the name of country, similarly there are different names of countries like Sri Lanka , China etc.
Kindly someone help.
Thanks.
Can someone guide with a formula, just want to identify name of a country present in a line in a cell, for eg there is an address "1023 building road, street kingkong, Nepal" i have thousands lines like these in a column, need a formula which should give return value as "Nepal" since its the name of country, similarly there are different names of countries like Sri Lanka , China etc.
Kindly someone help.
Thanks.