Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help needed in Excel
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 , South 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 , Saudi Arabia , Syria, Turkmenistan, United Arab Emirates , Yemen I would need to categorize them according to continent in the excel sheet. How do i go about doing that? Thanks in advance. |
#2
|
|||
|
|||
In columns or rows maybe a table the choice is yours.
Here's a link to get you started: http://www.worldatlas.com/cntycont.htm Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB excel help needed | Excel Programming | |||
Excel vba help needed | Excel Programming | |||
ActiveX Plugin needed in Excel 2000 missing from Excel 2003 | Excel Programming | |||
help needed with excel 97 | New Users to Excel | |||
VB code needed for running newer excel version macros in older excel versions | Excel Programming |