English fixtures in excel?

bobbyg

Sorry to start a new thread about this but I have searched everywhere and can’t find it.

Does anyone know if you can get all the weekend English fixtures in an excel spreadsheet?

I know I can copy and paste them from BBC etc. but when I do this it puts the full fixture (both teams) in one cell and I need a separate cell for each team, if that makes sense?

Or does anyone know a way of separating the teams out on excel once I have pasted if from BBC?

parker kent

Splitting cells is pretty handy.

http://office.microsoft.com/en-us/excel-help/merge-or-split-cells-or-cell-contents-HP005251021.aspx

parker kent

Oh and you are looking for this bit

Split the contents of cells across multiple cells

You cannot split a cell or range of cells that was not previously merged. You can, however, divide the contents of unmerged cells and display them across other cells.

Select the cell, the range of cells, or the entire column that contains the text values that you want to divide across other cells. A range can be any number of rows tall, but no more than one column wide.
IMPORTANT Unless there are one or more blank columns to the right of the selected column, the data to the right of the selected column will be overwritten.

On the Data menu, click Text to Columns.
Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.
NOTE For help with completing all the steps of the wizard, click Help in the Convert to Text Columns Wizard.

parker kent

Oh and to complete the bombardment, here are the fixtures in excel!

http://www.excel-fixtures.com/barclays-premier-league/

pickarooney

That's the response of a man named after two superheroes' alter-egos.