Spreadsheet: 855983d1705408653-how-to-add-without-to-the-end-of-each-references-for-several-defined-names-add-a-character-to-the-end-of-the-defined-names-ranges
Sheet: Sheet1

Continent | Country | Capital | City | Town | Population | GDP (b) | Employment | Unemployment | Male | Female |  | Continent | Country
Africa (con) | Nigeria (cou) | Abuja (cap) | Lagos (cit) | Victoria Island (tow) | 523571 | 31 |  |  |  |  |  |  |  | Ghana (cou) | Kenya (cou) | Nigeria (cou) | South Africa (cou)
Africa (con) | Nigeria (cou) | Abuja (cap) | Lagos (cit) | Ikeja (tow) | 499563 | 49 |  |  |  |  |  | Asia (con) |  | India (cou) | Indonesia (cou) | Japan (cou) | Malaysia (cou) | Saudi Arabia (cou) | South Korea (cou) | Thailand (cou) | Vietnam (cou)
Africa (con) | Nigeria (cou) | Abuja (cap) | Kano (cit) | [NAME] (tow) | 475556 | 27 |  |  |  |  |  | Europe (con) |  | Germany (cou) | Greece (cou) | Italy (cou) | Netherlands (cou) | Portugal (cou) | Spain (cou) | Sweden (cou) | [NAME] (cou)
Africa (con) | Nigeria (cou) | Abuja (cap) | Kano (cit) | [NAME] (tow) | 451548 | 53
Africa (con) | South Africa (cou) | Cape Town (cap) | Johannesburg (cit) | Sandton (tow) | 427541 | 1 |  |  |  |  |  | Country | Capital
Africa (con) | South Africa (cou) | Cape Town (cap) | Johannesburg (cit) | Soweto (tow) | 403533 | 6
Africa (con) | South Africa (cou) | Cape Town (cap) | Cape Town (cit) | Stellenbosch (tow) | 379526 | 11 |  |  |  |  |  | Egypt (cou)
Africa (con) | South Africa (cou) | Cape Town (cap) | Cape Town (cit) | [NAME] (tow) | 355518 | 47 |  |  |  |  |  | France (cou)
Africa (con) | Kenya (cou) | Nairobi (cap) | Mombasa (cit) | Nyali (tow) | 331511 | 5 |  |  |  |  |  | Germany (cou)
Africa (con) | Kenya (cou) | Nairobi (cap) | Mombasa (cit) | Mtwapa (tow) | 307503 | 8 |  |  |  |  |  | Ghana (cou)
Africa (con) | Kenya (cou) | Nairobi (cap) | Kisumu (cit) | Kondele (tow) | 283496 | 14 |  |  |  |  |  | Greece (cou)
Africa (con) | Kenya (cou) | Nairobi (cap) | Kisumu (cit) | [NAME] (tow) | 259488 | 51 |  |  |  |  |  | India (cou)
Africa (con) | Egypt (cou) | Cairo (cap) | [NAME] (cit) | [NAME] (tow) | 235481 | 21 |  |  |  |  |  | Indonesia (cou)
Africa (con) | Egypt (cou) | Cairo (cap) | [NAME] (cit) | Moharram [NAME] (tow) | 211473 | 29 |  |  |  |  |  | Italy (cou)
Africa (con) | Egypt (cou) | Cairo (cap) | [NAME] (cit) | [NAME] (tow) | 187466 | 12 |  |  |  |  |  | Japan (cou)
Africa (con) | Egypt (cou) | Cairo (cap) | [NAME] (cit) | Dokki (tow) | 163458 | 4 |  |  |  |  |  | Kenya (cou)
Africa (con) | Ghana (cou) | Accra (cap) | Kumasi (cit) | [NAME] (tow) | 139451 | 7 |  |  |  |  |  | Malaysia (cou)
Africa (con) | Ghana (cou) | Accra (cap) | Kumasi (cit) | [NAME] (tow) | 115443 | 39 |  |  |  |  |  | Netherlands (cou)
Africa (con) | Ghana (cou) | Accra (cap) | Tamale (cit) | Sakasaka (tow) | 91436 | 9 |  |  |  |  |  | Nigeria (cou)
Africa (con) | Ghana (cou) | Accra (cap) | Tamale (cit) | Tishigu (tow) | 67428 | 44 |  |  |  |  |  | Portugal (cou)
Asia (con) | China (cou) | Beijing (cap) | Shanghai (cit) | Pudong (tow) | 823571 | 34 |  |  |  |  |  | Saudi Arabia (cou)
Asia (con) | China (cou) | Beijing (cap) | Shanghai (cit) | Xuhui (tow) | 799563 | 20 |  |  |  |  |  | South Africa (cou)
Asia (con) | India (cou) | New Delhi (cap) | Mumbai (cit) | [NAME] (tow) | 775556 | 42 |  |  |  |  |  | South Korea (cou)
Asia (con) | India (cou) | New Delhi (cap) | Mumbai (cit) | Andheri (tow) | 751548 | 48 |  |  |  |  |  | Spain (cou)
Asia (con) | Japan (cou) | Tokyo (cap) | Tokyo (cit) | Shinjuku (tow) | 727541 | 37 |  |  |  |  |  | Sweden (cou)
Asia (con) | Japan (cou) | Tokyo (cap) | Tokyo (cit) | Shibuya (tow) | 703533 | 45 |  |  |  |  |  | Thailand (cou)
Asia (con) | South Korea (cou) | Seoul (cap) | Seoul (cit) | [NAME] (tow) | 679526 | 13 |  |  |  |  |  | [NAME] (cou)
Asia (con) | South Korea (cou) | Seoul (cap) | Seoul (cit) | Mapo (tow) | 655518 | 15 |  |  |  |  |  | Vietnam (cou)
Asia (con) | Indonesia (cou) | Jakarta (cap) | Surabaya (cit) | [NAME] (tow) | 631511 | 56
Asia (con) | Indonesia (cou) | Jakarta (cap) | Surabaya (cit) | [NAME] (tow) | 607503 | 23 |  |  |  |  |  | Capital | City
Asia (con) | Thailand (cou) | Bangkok (cap) | [NAME] (cit) | Nimman (tow) | 583496 | 35 |  |  |  |  |  |  |  | Lagos (cit)
Asia (con) | Thailand (cou) | Bangkok (cap) | [NAME] (cit) | Old City (tow) | 559488 | 17 |  |  |  |  |  | Accra (cap) |  | Tamale (cit)
Asia (con) | Saudi Arabia (cou) | Riyadh (cap) | Jeddah (cit) | Al-Balad (tow) | 535481 | 10 |  |  |  |  |  | [NAME] (cap)
Asia (con) | Saudi Arabia (cou) | Riyadh (cap) | Jeddah (cit) | [NAME] (tow) | 511473 | 43 |  |  |  |  |  | Athens (cap)
Asia (con) | Vietnam (cou) | Hanoi (cap) | [NAME] (cit) | [NAME] (tow) | 487466 | 50 |  |  |  |  |  | Bangkok (cap)
Asia (con) | Vietnam (cou) | Hanoi (cap) | [NAME] (cit) | District 1 (tow) | 463458 | 22 |  |  |  |  |  | Beijing (cap)
Asia (con) | Malaysia (cou) | Kuala Lumpur (cap) | Penang (cit) | Georgetown (tow) | 439451 | 28 |  |  |  |  |  | Berlin (cap)
Asia (con) | Malaysia (cou) | Kuala Lumpur (cap) | Penang (cit) | Batu Ferringhi (tow) | 415443 | 19 |  |  |  |  |  | Cairo (cap) |  | [NAME] (cit)
Europe (con) | France (cou) | Paris (cap) | Paris (cit) | Montmartre (tow) | 723571 | 36 |  |  |  |  |  | Cape Town (cap) |  | Johannesburg (cit)
Europe (con) | France (cou) | Paris (cap) | Paris (cit) | [NAME] (tow) | 699563 | 18 |  |  |  |  |  | Hanoi (cap)
Europe (con) | Germany (cou) | Berlin (cap) | Berlin (cit) | [NAME] (tow) | 675556 | 25 |  |  |  |  |  | Jakarta (cap)
Europe (con) | Germany (cou) | Berlin (cap) | Berlin (cit) | [NAME] (tow) | 651548 | 54 |  |  |  |  |  | Kuala Lumpur (cap)
Europe (con) | [NAME] (cou) | mLondon (cap) | London (cit) | Soho (tow) | 627541 | 3 |  |  |  |  |  | Lisbon (cap)
Europe (con) | [NAME] (cou) | mLondon (cap) | London (cit) | Camden Town (tow) | 603533 | 24 |  |  |  |  |  | Madrid (cap)
Europe (con) | Italy (cou) | Rome (cap) | Rome (cit) | Trastevere (tow) | 579526 | 16 |  |  |  |  |  | mLondon (cap)
Europe (con) | Italy (cou) | Rome (cap) | Rome (cit) | Testaccio (tow) | 555518 | 46 |  |  |  |  |  | Nairobi (cap) |  | Mombasa (cit)
Europe (con) | Sweden (cou) | Stockholm (cap) | Stockholm (cit) | Södermalm (tow) | 531511 | 33 |  |  |  |  |  | New Delhi (cap)
Europe (con) | Sweden (cou) | Stockholm (cap) | Stockholm (cit) | Östermalm (tow) | 507503 | 32 |  |  |  |  |  | Paris (cap)
Europe (con) | Spain (cou) | Madrid (cap) | Barcelona (cit) | [NAME] (tow) | 483496 | 40 |  |  |  |  |  | Riyadh (cap)
Europe (con) | Spain (cou) | Madrid (cap) | Barcelona (cit) | [NAME] (tow) | 459488 | 55 |  |  |  |  |  | Rome (cap)
Europe (con) | Netherlands (cou) | [NAME] (cap) | Amsterdam (cit) | [NAME] (tow) | 435481 | 30 |  |  |  |  |  | Seoul (cap)
Europe (con) | Netherlands (cou) | [NAME] (cap) | Amsterdam (cit) | [NAME] (tow) | 411473 | 26 |  |  |  |  |  | Stockholm (cap)
Europe (con) | Greece (cou) | Athens (cap) | Thessaloniki (cit) | Ladadika (tow) | 387466 | 52 |  |  |  |  |  | Tokyo (cap)
Europe (con) | Greece (cou) | Athens (cap) | Thessaloniki (cit) | Ano [NAME] (tow) | 363458 | 2
Europe (con) | Portugal (cou) | Lisbon (cap) | Porto (cit) | [NAME] (tow) | 339451 | 38 |  |  |  |  |  | City | Town
Europe (con) | Portugal (cou) | Lisbon (cap) | Porto (cit) | Foz do Douro (tow) | 315443 | 41 |  |  |  |  |  |  |  | Moharram [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Amsterdam (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Barcelona (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Berlin (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Cape Town (cit) |  | Stellenbosch (tow)
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (cit) |  | Old City (tow)
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] (cit) |  | District 1 (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Jeddah (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Johannesburg (cit) |  | Soweto (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Kano (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Kisumu (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Kumasi (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Lagos (cit) |  | Victoria Island (tow)
 |  |  |  |  |  |  |  |  |  |  |  | London (cit) |  | Soho (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Mombasa (cit) |  | Nyali (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Mumbai (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Paris (cit) |  | Montmartre (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Penang (cit) |  | Georgetown (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Porto (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Rome (cit) |  | Trastevere (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Seoul (cit) |  | Mapo (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Shanghai (cit) |  | Xuhui (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Stockholm (cit) |  | Södermalm (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Surabaya (cit) |  | [NAME] (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Tamale (cit) |  | Tishigu (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Thessaloniki (cit) |  | Ladadika (tow)
 |  |  |  |  |  |  |  |  |  |  |  | Tokyo (cit) |  | Shinjuku (tow)