Pasting Vegas odds from website

[JenniferMurphy]

I'm using my grandson's interest in his local NFL team to teach him about probability. I found a website that gives the Vegas odds (futures) for each NFL team to win the Super Bowl. Here's one of them:

http://www.vegasinsider.com/nfl/odds/futures/

I'd like to copy this data into a spreadsheet so I can do some calculations. I'd like to avoid having to type the data. But when I copy the data to the clipboard and then paste it into the spreadsheet, any odds that look like a date (6/1, 8/1) are converted into a date. If I preformat the cells as text and use Paste Special with the text option, I can get them to come in as text. But what I'd really like to do is get the numerator and denominator into separate cells.

So instead of

Denver Broncos	6/1
Seattle Seahawks	6/1
New England Patriots	8/1
Green Bay Packers	11/1
New Orleans Saints	11/1
San Francisco 49ers	12/1

<tbody>
</tbody>

I'd like to get

Denver Broncos	6	1
Seattle Seahawks	6	1
New England Patriots	8	1
Green Bay Packers	11	1
New Orleans Saints	11	1
San Francisco 49ers	12	1

<tbody>
</tbody>

Is there a simple way to do that?

 

[JenniferMurphy]

Sorry, everyone. I found the Text to Columns facility on the Data tab. Problem solved.