Importing .txt file into Excel

Giganews Newsgroups
Subject: Importing .txt file into Excel
Posted by:  Simon (thompson…@hotmail.com)
Date: Tue, 7 Oct 2003

Hi, I have a long list of names and address (text document .txt), the list
looks like the following

All Saints, Carnegie St
corner with Caledonian Road
Islington
N1 9QD
GB
Denomination Church of England
Phone 020 7837 0720
Fax
Email

Brixton - UCKG HelpCentre
386-388 Brixton Road
London
SW9 7AW
GB
Denomination Pentecostal
Phone 020 7738 4887
Fax 020 7738 4887
Email
Web Site

Etc etc

How do I import this list into specific columns in Excel, such as Company,
Address1, Address 2 etc?
Any help would be greatly appreciated.
Thanks
Simon

Replies