Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 414
- Office Version
- 365
- Platform
- Windows
Hi Forum
May I ask members if they would be kind enough to supply a formula to split the below info into separate columns by way of formula. An explanation of the info is as follows
2-10 - DARK MYSTERY - 5/1 > 3/1 > 2/1 > 1/1
first numbers is a time 2-10
Then a horses name Dark Mystery
Then a set of betting odds 5/1 > 3/1 > 2/1 > 1/1 (this line of odds can be just one set
ie 5/1
upto 7 sets
ie 5/1 > 3/1 > 2/1 > 1/1 > 8/13 > 1/2 > 4/11
I would also add that the info would start in cell A1 and can run down into cell A150 so I would need to able to copy down the formula per line.
So I would like it set out that if the info is in Col A1 then it would follow that in
Col B1 = time
Col C1 = Horse Name
Col D1 = Odds
May I also ask if it would be possible to change the time layout to a decimal thus instead of 2-10 it would read 2.10
Many thanks in advance for any help provided as it will be much appreciated and I will be sure to provide feedback as is neccessary. Thanks again.
Regards
PS Image attached also for interest.
May I ask members if they would be kind enough to supply a formula to split the below info into separate columns by way of formula. An explanation of the info is as follows
2-10 - DARK MYSTERY - 5/1 > 3/1 > 2/1 > 1/1
first numbers is a time 2-10
Then a horses name Dark Mystery
Then a set of betting odds 5/1 > 3/1 > 2/1 > 1/1 (this line of odds can be just one set
ie 5/1
upto 7 sets
ie 5/1 > 3/1 > 2/1 > 1/1 > 8/13 > 1/2 > 4/11
I would also add that the info would start in cell A1 and can run down into cell A150 so I would need to able to copy down the formula per line.
So I would like it set out that if the info is in Col A1 then it would follow that in
Col B1 = time
Col C1 = Horse Name
Col D1 = Odds
May I also ask if it would be possible to change the time layout to a decimal thus instead of 2-10 it would read 2.10
Many thanks in advance for any help provided as it will be much appreciated and I will be sure to provide feedback as is neccessary. Thanks again.
Regards
PS Image attached also for interest.