country list

Hi there,

I am trying to create a data validation list containing all countries. How
can I get such a list into Excel without actually having to type every
country?

Thanks in advance

http://dir.yahoo.com/Regional/Countries/

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BigBloke" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> I am trying to create a data validation list containing all countries. How
> can I get such a list into Excel without actually having to type every
> country?
>
> Thanks in advance

or

Afghanistan
Aland
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Brazil
British Virgin Islands
Brunei
Bulgaria
Burkina Faso
Burundi
Cabo Verde
Cambodia
Cameroun
Canada
Cayman Islands
Central African Republic
Chile
China
Colombia
Comoros
Congo (Dem. Rep.)
Congo (Rep.)
Cook Islands
Costa Rica
Côte d'Ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Eritrea
Estonia
Ethiopia
Falkland Islands
Faroes
Fiji
Finland
France
French Guyana
French Polynesia
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
Haïti
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Kiribati
Kuwait
Kyrgystan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macao
Macedonia (Former Yugoslav Republic)
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Man
Marshall Islands
Martinique
Mauritania
Mauritius
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Cyprus
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Palestinian Authority
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Puerto Rico
Qatar
Réunion
Romania
Russia
Rwanda
St. Helena
St. Kitts and Nevis
St. Lucia
Samoa
San Marino
São Tomé and Príncipe
Saudi Arabia
Senegal
Serbia and Montenegro
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Korea
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Taiwan
Tajikistan
Tanzania
Tchad
Thailand
Togo
Tokelau
Tonga
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
United States Virgin Islands
Uruguay
Uzbekistan
Vanuatu
Vatican
Venezuela
Viet Nam
Wallis and Futuna
Yemen
Zambia
Zimbabwe


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BigBloke" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> I am trying to create a data validation list containing all countries. How
> can I get such a list into Excel without actually having to type every
> country?
>
> Thanks in advance

Thanks :-)

"Bob Phillips" wrote:

> or
>
> Afghanistan
> Aland
> Albania
> Algeria
> American Samoa
> Andorra
> Angola
> Anguilla
> Argentina
> Armenia
> Aruba
> Australia
> Austria
> Azerbaijan
> Bahamas
> Bahrain
> Bangladesh
> Barbados
> Belarus
> Belgium
> Belize
> Benin
> Bermuda
> Bhutan
> Bolivia
> Bosnia and Herzegovina
> Botswana
> Brazil
> British Virgin Islands
> Brunei
> Bulgaria
> Burkina Faso
> Burundi
> Cabo Verde
> Cambodia
> Cameroun
> Canada
> Cayman Islands
> Central African Republic
> Chile
> China
> Colombia
> Comoros
> Congo (Dem. Rep.)
> Congo (Rep.)
> Cook Islands
> Costa Rica
> Côte d'Ivoire
> Croatia
> Cuba
> Cyprus
> Czech Republic
> Denmark
> Djibouti
> Dominica
> Dominican Republic
> East Timor
> Ecuador
> Egypt
> El Salvador
> Eritrea
> Estonia
> Ethiopia
> Falkland Islands
> Faroes
> Fiji
> Finland
> France
> French Guyana
> French Polynesia
> Gabon
> Gambia
> Georgia
> Germany
> Ghana
> Gibraltar
> Greece
> Greenland
> Grenada
> Guadeloupe
> Guam
> Guatemala
> Guernsey
> Guinea
> Guinea-Bissau
> Guyana
> Haïti
> Honduras
> Hong Kong
> Hungary
> Iceland
> India
> Indonesia
> Iran
> Iraq
> Ireland
> Israel
> Italy
> Jamaica
> Japan
> Jersey
> Jordan
> Kazakhstan
> Kenya
> Kiribati
> Kuwait
> Kyrgystan
> Laos
> Latvia
> Lebanon
> Lesotho
> Liberia
> Libya
> Liechtenstein
> Lithuania
> Luxembourg
> Macao
> Macedonia (Former Yugoslav Republic)
> Madagascar
> Malawi
> Malaysia
> Maldives
> Mali
> Malta
> Man
> Marshall Islands
> Martinique
> Mauritania
> Mauritius
> Mexico
> Micronesia
> Moldova
> Monaco
> Mongolia
> Montserrat
> Morocco
> Mozambique
> Myanmar
> Namibia
> Nepal
> Netherlands
> Netherlands Antilles
> New Caledonia
> New Zealand
> Nicaragua
> Niger
> Nigeria
> Niue
> Norfolk Island
> Northern Cyprus
> Northern Mariana Islands
> Norway
> Oman
> Pakistan
> Palau
> Palestinian Authority
> Panama
> Papua New Guinea
> Paraguay
> Peru
> Philippines
> Poland
> Portugal
> Puerto Rico
> Qatar
> Réunion
> Romania
> Russia
> Rwanda
> St. Helena
> St. Kitts and Nevis
> St. Lucia
> Samoa
> San Marino
> São Tomé and PrÃ*ncipe
> Saudi Arabia
> Senegal
> Serbia and Montenegro
> Seychelles
> Sierra Leone
> Singapore
> Slovakia
> Slovenia
> Solomon Islands
> Somalia
> South Africa
> South Korea
> Spain
> Sri Lanka
> Sudan
> Suriname
> Swaziland
> Sweden
> Switzerland
> Syria
> Taiwan
> Tajikistan
> Tanzania
> Tchad
> Thailand
> Togo
> Tokelau
> Tonga
> Trinidad and Tobago
> Tunisia
> Turkey
> Turkmenistan
> Tuvalu
> Uganda
> Ukraine
> United Arab Emirates
> United Kingdom
> United States
> United States Virgin Islands
> Uruguay
> Uzbekistan
> Vanuatu
> Vatican
> Venezuela
> Viet Nam
> Wallis and Futuna
> Yemen
> Zambia
> Zimbabwe
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "BigBloke" <[email protected]> wrote in message
> news:[email protected]...
> > Hi there,
> >
> > I am trying to create a data validation list containing all countries. How
> > can I get such a list into Excel without actually having to type every
> > country?
> >
> > Thanks in advance
>
>
>

Pleasure.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BigBloke" <[email protected]> wrote in message
news:[email protected]...
> Thanks :-)
>
> "Bob Phillips" wrote:
>
> > or
> >
> > Afghanistan
> > Aland
> > Albania
> > Algeria
> > American Samoa
> > Andorra
> > Angola
> > Anguilla
> > Argentina
> > Armenia
> > Aruba
> > Australia
> > Austria
> > Azerbaijan
> > Bahamas
> > Bahrain
> > Bangladesh
> > Barbados
> > Belarus
> > Belgium
> > Belize
> > Benin
> > Bermuda
> > Bhutan
> > Bolivia
> > Bosnia and Herzegovina
> > Botswana
> > Brazil
> > British Virgin Islands
> > Brunei
> > Bulgaria
> > Burkina Faso
> > Burundi
> > Cabo Verde
> > Cambodia
> > Cameroun
> > Canada
> > Cayman Islands
> > Central African Republic
> > Chile
> > China
> > Colombia
> > Comoros
> > Congo (Dem. Rep.)
> > Congo (Rep.)
> > Cook Islands
> > Costa Rica
> > Côte d'Ivoire
> > Croatia
> > Cuba
> > Cyprus
> > Czech Republic
> > Denmark
> > Djibouti
> > Dominica
> > Dominican Republic
> > East Timor
> > Ecuador
> > Egypt
> > El Salvador
> > Eritrea
> > Estonia
> > Ethiopia
> > Falkland Islands
> > Faroes
> > Fiji
> > Finland
> > France
> > French Guyana
> > French Polynesia
> > Gabon
> > Gambia
> > Georgia
> > Germany
> > Ghana
> > Gibraltar
> > Greece
> > Greenland
> > Grenada
> > Guadeloupe
> > Guam
> > Guatemala
> > Guernsey
> > Guinea
> > Guinea-Bissau
> > Guyana
> > Haïti
> > Honduras
> > Hong Kong
> > Hungary
> > Iceland
> > India
> > Indonesia
> > Iran
> > Iraq
> > Ireland
> > Israel
> > Italy
> > Jamaica
> > Japan
> > Jersey
> > Jordan
> > Kazakhstan
> > Kenya
> > Kiribati
> > Kuwait
> > Kyrgystan
> > Laos
> > Latvia
> > Lebanon
> > Lesotho
> > Liberia
> > Libya
> > Liechtenstein
> > Lithuania
> > Luxembourg
> > Macao
> > Macedonia (Former Yugoslav Republic)
> > Madagascar
> > Malawi
> > Malaysia
> > Maldives
> > Mali
> > Malta
> > Man
> > Marshall Islands
> > Martinique
> > Mauritania
> > Mauritius
> > Mexico
> > Micronesia
> > Moldova
> > Monaco
> > Mongolia
> > Montserrat
> > Morocco
> > Mozambique
> > Myanmar
> > Namibia
> > Nepal
> > Netherlands
> > Netherlands Antilles
> > New Caledonia
> > New Zealand
> > Nicaragua
> > Niger
> > Nigeria
> > Niue
> > Norfolk Island
> > Northern Cyprus
> > Northern Mariana Islands
> > Norway
> > Oman
> > Pakistan
> > Palau
> > Palestinian Authority
> > Panama
> > Papua New Guinea
> > Paraguay
> > Peru
> > Philippines
> > Poland
> > Portugal
> > Puerto Rico
> > Qatar
> > Réunion
> > Romania
> > Russia
> > Rwanda
> > St. Helena
> > St. Kitts and Nevis
> > St. Lucia
> > Samoa
> > San Marino
> > São Tomé and Príncipe
> > Saudi Arabia
> > Senegal
> > Serbia and Montenegro
> > Seychelles
> > Sierra Leone
> > Singapore
> > Slovakia
> > Slovenia
> > Solomon Islands
> > Somalia
> > South Africa
> > South Korea
> > Spain
> > Sri Lanka
> > Sudan
> > Suriname
> > Swaziland
> > Sweden
> > Switzerland
> > Syria
> > Taiwan
> > Tajikistan
> > Tanzania
> > Tchad
> > Thailand
> > Togo
> > Tokelau
> > Tonga
> > Trinidad and Tobago
> > Tunisia
> > Turkey
> > Turkmenistan
> > Tuvalu
> > Uganda
> > Ukraine
> > United Arab Emirates
> > United Kingdom
> > United States
> > United States Virgin Islands
> > Uruguay
> > Uzbekistan
> > Vanuatu
> > Vatican
> > Venezuela
> > Viet Nam
> > Wallis and Futuna
> > Yemen
> > Zambia
> > Zimbabwe
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "BigBloke" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi there,
> > >
> > > I am trying to create a data validation list containing all countries.
How
> > > can I get such a list into Excel without actually having to type every
> > > country?
> > >
> > > Thanks in advance
> >
> >
> >