Hi

I have an excel query and I'd appreciate your help.

I am trying to extract country names from a string text, and whilst most of my results are correct, there are some anomalies

If the string has the text 'woman'.. my formula matches 'oman'
If the string has the text 'indian' .. my formula matches 'india'
etc.

I need an exact match and I can't figure out how to do this.

I attach a sample file.Country formula.xls