Format Data from Web so it's usable

Hello All, please help!

I think I have a similar problem as this thread http://www.excelforum.com/excel-prog...o-columns.html. The answer is probably somewhere in the forum, but I looked around and I can't figure it out on my own.

Basically, I copied some data off a website and now I am trying to organize it so it is usable. Here is my example. I would like to put the data below into usable columns. The only data I need is the hospital name (column A), location (column B), Births (column C), and Beds (column D).

This is how the data currently appears in excel:

Banner Desert Medical Center*— Mesa, AZ
Hospital Type General medical and surgical ER Visits: 83,212
Admissions/Visits: 41,542*Inpatient*/ 133,208*Outpatient Births: 7,552
Surgeries: 8,793*Inpatient*/ 9,581*Outpatient Beds: 518
Banner Thunderbird Medical Center*— Glendale, AZ
Hospital Type General medical and surgical ER Visits: 65,827
Admissions/Visits: 29,189*Inpatient*/ 256,950*Outpatient Births: 4,821
Surgeries: 10,448*Inpatient*/ 4,660*Outpatient Beds: 376

Thanks for any advice!

Document is attached.