|Handicapping "Think Tank" technical handicapping and statistics|
| ||LinkBack||Thread Tools|
If I copy and paste team win/loss records from another software program to an excel spreadsheet the whole record for each team ends up in one cell. Say for example the win/loss record for team x is 19-3, is there any easy way to get 19 in one cell and 3 in another cell after I have already pasted? Can you divide the column/cell in two and keep the wins in the first column and the losses in the second column?
I dont think there is an easy way to cut and paste into Excel from another program. I would suggest that you open up the file using the original software that was used and then export it to your desktop as a tab delimited file. Then open Excel and open up the exported file. That should get all of the columns to contain the information that was in the original file.
Hope that helps.
Highlight the column in question
Text to Columns
Delimited (Fixed can also work depends on the data)
In the example you showed, under delimiters:
Put a "-" in the box next to others
Most times you can do whatever parsing you need using text to columns. Sometimes you need to do a combination of "Fixed width" and "delimited" parsing. If your data has the space amount of spaces, like most of the data from Don Best Archives, fixed width parsing can be useful.
An easy way to find out if the data that you have copied/pasted is in fixed width is to change the font to Courier. If everything lines up nicely, you can do fixed-width parsing.
In this case, delimited parsing probably is what is needed.