Hi,

My hobby is punting. I wager relatively small amounts
usually spread over 2 to 4 runners. I use an Excel
spreadsheet to manipulate form data from which I make my
selections and record my bets. I use a regular internet
betting agency to place my bets. My problem is that
because I wager only small amounts, I cannot place the
bets in sufficient time to capture the latest dividends
and this usually results in a loss.

Is there a way that I can copy my data to another section
of my spreadsheet and then parse it in some way so that I
can then, by one click, copy and paste the selections as a
block directly to the input section of the betting agency
site.

Their input box appears to be just formatted text with one
entry per line parsed in the format of:-
RR-04-WP-00005.0-00000.0/02/ which is, in order:-
RaceVenue-No-WinPlace-WinAmt-PlaceAmt/RunnerNo/

The fields are separated by dashes except for the last two
which have forward slashes. I don't know what this means
but the above format is how it appears in their input box
when the data is entered manually.

Could anyone help with this please?
Regards,
Richard