Can you give the url along with a STEP BY STEP explanation of what you are
now doing.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Excel Expert Wannabe" <Excel Expert
wrote in message ...
I have a great list of Hospitals from the web with everything written in a
long list like this:

Albany Medical College, Union University
http://www.amc.edu/academic/
43 New Scotland Avenue
Albany, NY 12208
Tel: +1 518 262 5548, Fax: +1 518 262 5029

Albert Einstein College of Medicine, Yeshiva University
http://www.aecom.yu.edu/
1300 Morris Park Avenue,
Bronx, NY 10461
Tel: +1 718 430 2106, Fax: +1 718 430 8825

What's the fastest way to convert this into a database in excel to look
something like this:

One column for each of these: School, Web address, Address, City, State,
zip, Phone, Fax

We do this manually and depending how long the list is, it can take
forever.