Yeah, that's why I wrote:

Assuming string in A2 (and country names containing no spaces)

Can't think of a convenient way to use formulae to parse in that case...

Doesn't mean it can't be done, of course.


In article ,
Ron Rosenfeld wrote:

When I try your solution here, it fails with countries that have more than one
name. For example, Great Britain or United States.
--ron