pasting data in each cell

does anybody know how to convert this raw data in excel, but keep them organize as possible.

I want the win/loss record, team name, month, spread, and total in each cell.

AIR FORCE (FT)

(SUR: 9-4 PSR: 5-8 O-U: 3-9)

S.04 N'W'TERN ST. L -46 65-21

S.11 BYU# W -1' 35-14 u50

S.18 Oklahoma W +16' 24-27 u53'

S.25 Wyoming L -13' 20-14 u50

O.02 NAVY L -9' 14-6 u50

O.09 COLO. ST. L -24 49-27 o47'

O.16* San Diego St. L -1 25-27 u53'

O.23* Tcu L +18' 7-38 u50'

O.30* UTAH W +7 23-28 u55

N.06 Army W -6' 42-22 o48'

N.13* N. MEXICO L -33 48-23 o56'

N.18* Unlv L -19 35-20 u56'

D.27* Georgia Tech W -2' 14-7 u55'

(Indepedence Bowl)

AKRON (AT)

(SUR: 1-11 PSR: 5-7 O-U: 5-6-1)

S.04* SYRACUSE L +8 3-29 u42

S.11 G.-WEBB-OT L -15' 37-38 o47

S.18* Kentucky L +24' 10-47 o51'

S.25* Indiana W +22' 20-35 u56'

O.02* N. ILLINOIS# L +13' 14-50 o47

O.09 Kent St. W +17 17-28 u47

O.16 Ohio L +16' 10-38 n48

O.23 W. MICH. L +7' 10-56 o51

O.30 Temple L +29' 0-30 u49'

N.06 Ball St.-OT W +13' 30-37 o49

N.17* MIAMI-O. W +9 14-19 u46

N.26 BUFFALO W -1 22-14 u42'

I plan to importing a large amount of data from the website below.

http://www.goldsheet.com/gs_new/hist...=10cfblog.html

Have a look at the Data--Text to columns--delimited by--- feature in Excel

Here's a Macro that will import the data into cells. Im not the greatest with web data but it will work.

TestData.xls

Please Login or Register  to view this content.

Sorry I should of told you, you need to make reference to the Microsoft XML, v3.0 or higher. Tools>References, and scroll down to you find Microsoft XML, v3.0 or higher.

Or you can just copy this code which uses late binding to create the object

Please Login or Register  to view this content.

Just looked them over and all the pages are set up different. So it would be to difficult.

Yea its the same thing looks like over the years they have changed the layout of the page.
Would by the time it took to code up something that would work on them all someone could manually enter them.

Heres an example this is what there old pages look like

HTML Code: 

and these are there new pages

HTML Code: 

Best I could do.


CF.xlsm