# Pasting Vegas odds from website

#### JenniferMurphy

##### Well-known Member
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.

 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?

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### JenniferMurphy

##### Well-known Member
Sorry, everyone. I found the Text to Columns facility on the Data tab. Problem solved.

Replies
6
Views
127
Replies
8
Views
227
Replies
2
Views
182
Replies
6
Views
343
Replies
3
Views
483

1,191,517
Messages
5,987,059
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back