X
Xcalibur_9017
I have a group of data in the cell and they looked like this:
Afghanistan , Bangladesh , China , Hong Kong , India , South Korea
Malaysia , Nepal , Pakistan , Philippines , Singapore, Sri Lanka
Taiwan , Vietnam, Algeria , Angola , Central African Republic, Comoros
Congo, Democratic Republic of , Ethiopia , Senegal , Seychelles , Sout
Africa , Sudan , Swaziland , Uganda , Zimbabwe , Paraguay , Greece
Luxembourg , Macedonia , Malta , Poland , Slovakia , Slovenia , Spain
Switzerland , United Kingdom , Armenia, Azerbaijan , Bahrain , Egypt
Georgia , Iran , Iraq , Jordan , Kuwait , Lebanon , Oman , Qatar , Saud
Arabia , Syria, Turkmenistan, United Arab Emirates , Yemen
I would need to categorize them according to continent in the exce
sheet.
How do i go about doing that?
Thanks in advance
Afghanistan , Bangladesh , China , Hong Kong , India , South Korea
Malaysia , Nepal , Pakistan , Philippines , Singapore, Sri Lanka
Taiwan , Vietnam, Algeria , Angola , Central African Republic, Comoros
Congo, Democratic Republic of , Ethiopia , Senegal , Seychelles , Sout
Africa , Sudan , Swaziland , Uganda , Zimbabwe , Paraguay , Greece
Luxembourg , Macedonia , Malta , Poland , Slovakia , Slovenia , Spain
Switzerland , United Kingdom , Armenia, Azerbaijan , Bahrain , Egypt
Georgia , Iran , Iraq , Jordan , Kuwait , Lebanon , Oman , Qatar , Saud
Arabia , Syria, Turkmenistan, United Arab Emirates , Yemen
I would need to categorize them according to continent in the exce
sheet.
How do i go about doing that?
Thanks in advance