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

larainalton

New Member
Joined
Jan 29, 2004
Messages
2
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?
:rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes: :rolleyes:

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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Yesuslave

Active Member
Joined
Sep 19, 2003
Messages
297
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,462
Messages
5,596,280
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top