PDA

View Full Version : Copying & pasting Spot Plays into Excel


Roghaltz
21st July 2008, 07:34.06 PM
Hi,
Prior to the 7/23 update when I copied the results of my daily spot plays into Excel I could use the "Text to Columns" function to format it into neat columns.

It looks like that as of the 7/23 update it now pastes it directly as text. The problem is that the columns are no longer aligned, so there is a fair amount of manual cleanup to do because Excel doesn't break every row at the same place.

(I am using Excel 2007).

Any suggestions?

Thanks
Ezra (Roghaltz)

Rick
21st July 2008, 07:46.29 PM
I just did it in Excel 2007 without a problem.

After I pasted into a blank spreadsheet I highlighed from Post down to the last race and clicked on Text to Columns.

I went with Fixed width > Next > Finish.

I ended up with (K) and r in the same column

Rick
21st July 2008, 07:48.03 PM
That was using Get My Plays.

Roghaltz
22nd July 2008, 08:21.36 AM
That was using Get My Plays.

Thanks Rick. Seems to work fine now (I can use text to columns like I had been). I must've done something wrong yesterday.

Thanks
Ezra