Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
country list
http://dir.yahoo.com/Regional/Countries/
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "BigBloke" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
country list
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
country list
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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
country list
Pleasure.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "BigBloke" wrote in message ... 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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
country list
Už ste zabudli po slovensky???
Aj my nieÄo vieme. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Copying list item (a bit less vague) | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |