Removing duplicates names in single cell

Hi All,

I have a database which includes different countries names in single cell.

I like to remove the duplicate countries and keep an unique name for each country is enough.

I've attached example file for reference.

Regards
Elango

Hi Marc,

Thank you so much for the code. Which is working fine in the example file. Which not working in the data which i have.

My data range starts is from J27 and ends based on the availability of data. I have modified the code, however it is not working

Please help me!!!

Heres another way..

See attachment for working example..

Please Login or Register  to view this content.

Hi Apo,

I followed your way it worked perfectly. I really appreciate your help!

Thanks a lot!!!!

Elango