combine texts from two field and then delete duplicate.

[mshtuhin]

I have value like:

A1= India, United States, China, United Kingdom,
B1= India, China, Singapore, Iran, Canada,

I want result in C2=India, United States, China, United Kingdom, Singapore, Iran, Canada,

i.e combine all value but delete the duplicate, here duplicate is India and China.

Could you please assist?

Thanks
Tuhin

[mshtuhin]

Fair enough even if you can make it with the help of VB.

[mshtuhin]

Here is my attached.

Please note, I just posted same to Mr.Excel.com/forum, below is the link:
http://www.mrexcel.com/forum/showthr...00#post3208000

[texasalynn]

see post
http://www.mrexcel.com/forum/showthr...=1#post3208020

[mshtuhin]

hi,

given solution is absolutely perfect. Thank you so much

brgds
Tuhin