Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
Worksheet looks good in print, not so good on-screen | Excel Discussion (Misc queries) | |||
Excel - convert row address listing to columnar database | Excel Discussion (Misc queries) | |||
Convert MS Excel data to MS Access database | Excel Worksheet Functions | |||
Need a good template for a phone list | Excel Worksheet Functions |