Hi everybody,
I need your help with the file attached
I have a column consisting addresses with one or more than 1 countries
I want to exctract the countries either in 1 column, or more than 1 columns doesn't matter
For instance the cell is
"University of Lincoln, United Kingdom; Universidade Federal de Lavras, Departamento de Química, Caixa Postal 3037, Lavras, MG, 37200-000, Brazil"
I expect the result in column to be United Kingdom, Brazil
In short i want the excel to automatically produce the country/countries name from the string text
Any help is much appreciated
Thank you
I need your help with the file attached
I have a column consisting addresses with one or more than 1 countries
I want to exctract the countries either in 1 column, or more than 1 columns doesn't matter
For instance the cell is
"University of Lincoln, United Kingdom; Universidade Federal de Lavras, Departamento de Química, Caixa Postal 3037, Lavras, MG, 37200-000, Brazil"
I expect the result in column to be United Kingdom, Brazil
In short i want the excel to automatically produce the country/countries name from the string text
Any help is much appreciated
Thank you