Re:Please help me! - Mike (Tue Nov 30 15:19:43 1999)That's exactly what I wanted to do, now I can continue to finsh my spreadsheet that will help give us an advantage in Over/Under.
I'll try to post my o/u picks today. If you guys want the picks e-mailed to you every day, join my mailing list. E-mail me at prolineplays@xoommail.com to join.
DoughBoy
>Doughboy,
>
>Basically what I do is just highlight the sports select info right off the web page (or, I guess it would work off the html source as well since its between PRE tags) and copy and paste it into Excel.
>
>At this stage you probably notice that its all there in Excel but each line is in a single cell. Highlight the cells that the data is in and go to the menu Data...Text to Columns...
>
>Then go through the wizard by choosing "fixed width" - Note: "delimited" for consecutive space delimiters will not work because of blanks in the v and h point spread columns. After choosing "fixed width" insert the columns where you want, change the number format or skip columns if desired (I usually skip the time column), hit finish and it should be all nice and neat in Excel.
>
>Any questions let me know.
>
>Mike
>Big M Sports
>
>>Hey,
>>
>>Does anyone here know how to import data from a SportSelect game list (html format) into an MS Excel document, so that each piece of data (game number, time, odds) take up one cell each?
>>
>>I have found a formula that is about 70% on OVER/UNDERs and I am trying to make it into an easy to use format for you guys!
>>
>>Thanks,
>>DoughBoy
