im a verry green in VBA
i need to import a txt file to excel exemple down
1 China 1323591583
2 India 1156897766
3 United States 307212123
4 Indonesia 240271522
5 Brazil 198739269
6 Pakistan 174578558
7 Bangladesh 156050883
8 Nigeria 149229090
9 Russia 140041247
the final resust must be
col a number os country
col b name of country
col c number
the problem is that some countries have more tham 1 name separated
how can i solve this
gracias
Bookmarks