[Excel Expert Wannabe]

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.

[Dave]

Hi,
Is the info regarding each hospital in just one cell, or is it in 5 cells
(one cell for each line)?
Regards - Dave.

[Ed Ferrero[_2_]]

Hi,

A sample file showing how to do this is at
http://www.edferrero.com/Content/ConvColumntoRow.xls

Uses OFFSET functions to put data into rows
like =OFFSET(input!$A$1,(COLUMN(A2)-1)+(ROW(A2)-2)*11,0)

Then uses IF and FIND to parse output
like
=IF(output1!A2=0,"",RIGHT(output1!A2,LEN(output1!A 2)-FIND(":",output1!A2)-1))

Probably easier to explain in the sample workbook.

Ed Ferrero
www.edferrero.com



"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.

[Don Guillett]

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.