Copy and paste

[Hill16]

Strange problem - I'm using the Excel sheet from here to place bets from a list of horses:

viewtopic.php?f=8&t=3557

When I copy and paste the list, it doesn't seem to work - but if I actually type them, it does. Any ideas?

Thanks in advance,

Wayne

[mak]

where from you copy?
probably you need to user the trim function in excel... google it
the 2 names should be exactly the same.. check your source spelling.

[Hill16]

Hi, I'm copying it from a racing system builder excel sheet but even when the spelling and spacing etc are exactly the same, it still fails. Yet when I re-type over it, it works!

[MarkRussell]

Hi, I'm copying it from a racing system builder excel sheet but even when the spelling and spacing etc are exactly the same, it still fails. Yet when I re-type over it, it works!

Hi,

There could be hidden spaces at the end of your copied selection names which would make it not work.
If you go on to one of the selection names and press F2 to edit does it show extra spaces at the end of name?
If yes, then you need to remove the spaces or adjust the place bets sheet to ignore them.

Regards,
Mark

[Hill16]

Thanks folks,

Yes, it looks like there is extra spaces at the end of the selection names. I'll remove them and try it out on Friday's racing. Thanks again,

Wayne

[Hill16]

Just wanted to say that the trim function worked - thanks a million.

By the way, do these spreadsheets work the same way for Betdaq or is there any difference?

Thanks.

[MarkRussell]

Just wanted to say that the trim function worked - thanks a million.

By the way, do these spreadsheets work the same way for Betdaq or is there any difference?

Thanks.

Hi,

It works in the same way.
There are some differences in that not all the same data is output from Betdaq due to it not being available.
What is there is output in the same cells as the Betfair version.

Regards,
Mark

[mak]

If I can recall correctly sometimes the bq horse names are not exactly the same as bf