how do I take a list of addresses and seperate it to its own

[larainalton]

Can anyone tell me how to take a list of addresses as follows, that are in excel coloum A and break them out into seperate coloums? Address in A Embassy in B Address in C and so on. Is this possible in excel or any other program?


Afghanistan
Canadian Embassy
Street No. 15, House No. 256, Wazir Akbar Khan, Kabul, Afghanistan     
(93) 70-294-281, 79-305-464    
canadakabul@yahoo.com

Albania
Consulate of Canada
Bulevardi Zhan d'Ark, Kulla Teknoprojekt, No. 2, Apt. 1, Tirana, Albania            
355 (42) 57254/ 355 (42) 57275  
355 (42) 275273
canadalb@canada.gov.al

Algeria
Canadian Embassy
18, rue Mustapha-Khalef, Ben Aknoun, Alger, Algeria     
Postal P.O. Box 48, Alger-Gare, 16000 Alger, Alger, Alger-Gare 16000, Algeria
(213) 2191-4951, 2191-4960  
(213) 2191-4973
alger@dfait-maeci.gc.ca

Angola
Consulate of Canada
Rua Rei Katyavala 113, Luanda, Angola  
244 (2) 448-371, 448-377, 448-366  
244 (2) 449-494
consul.can@angonet.org

Argentina  

Canadian Embassy
2828 Tagle, C1425EEH Buenos Aires, Argentina    
Postal P.O. Box 1598, C1000WAP , Buenos Aires, C1000WAP Correo Central, Argentina
54 (11) 4808-1000  
54 (11) 4808-1012
bairs@dfait-maeci.gc.ca    
www.dfait-maeci.gc.ca/bairs

Armenia
Consulate of Canada
25 Demirjian Street, No. 21, Yerevan, Armenia     
374 (1) 56-79-03  
374 (1) 56-79-03

Australia - Canberra  

Canadian High Commission
Commonwealth Avenue, Canberra ACT 2600, Australia   
61 (2) 6270-4000  
61 (2) 6270-4081
cnbra@dfait-maeci.gc.ca    
www.dfait-maeci.gc.ca/australia

Australia - Melbourne  

Consulate of Canada
Level 50, 101 Collins Street, Melbourne, Victoria 3000, Australia  
61 (3) 9653-9674

 

[Yesuslave]

Re: how do I take a list of addresses and seperate it to its

If you have Monarch (a program that does exactly this) you could do it very easily.


Josh