Gruss Forum • View topic

by **knot** » Sat Dec 08, 2007 5:13 pm

how would it be possible to have the race distance that is in cell A1 in cell X2. Please

by **Ian** » Sat Dec 08, 2007 5:45 pm

=IF(MID(A1,FIND(":",A1)+6,1)=" ",MID(A1,FIND(":",A1)+4,2),MID(A1,FIND(":",A1)+4,4))

That's my attempt - probably can be done neater.

by **danjuma** » Mon May 04, 2009 9:14 am

Ian wrote:=IF(MID(A1,FIND(":",A1)+6,1)=" ",MID(A1,FIND(":",A1)+4,2),MID(A1,FIND(":",A1)+4,4))

That's my attempt - probably can be done neater.

Ian (or anybody),

How could I extract the race venue in A1 to another cell instead?

Thanks

by **doris_day** » Mon May 04, 2009 1:12 pm

Try this. Paste the following into the cell you wish to paste the track:

=LEFT(A1,FIND(" ",A1)-1)

by **danjuma** » Mon May 04, 2009 6:40 pm

Works fine. Thanks a mill D_D, most grateful.

by **danjuma** » Mon Apr 05, 2010 5:13 pm

Could somebody please assist with this. I want to extract the race type from say the examples below which would normally be in cell A1 (i.e Hcap, Hcap Chs) into another cell say AA1. What formula could I use please? Many thanks.

Redc 5th Apr - 14:00 5f Hcap
Hunt 5th Apr - 17:40 2m4f Hcap Chs

by **osknows** » Mon Apr 05, 2010 6:47 pm

you could put this in a MODULE

Code: Select all: Function Sp(cell As Range, count As Integer) Sp = Split(cell.Value, " ")(count) End Function

then in excel use the following formulae

=Sp(cell, word_count)

eg if "Hunt 5th Apr - 17:40 2m4f Hcap Chs" is in cell A1 then

=Sp(A1,0) Hunt
=Sp(A1,1) 5th
=Sp(A1,2) Apr
=Sp(A1,3) -
=Sp(A1,4) 17:40
=Sp(A1,5) 2m4f
etc

by **danjuma** » Mon Apr 05, 2010 6:51 pm

Ok, done it a very crude way. If somebody has got a better, more efficient solution, please oblige. Thanks

=IF(MID(A1,FIND(":",A1)+6,1)=" ",MID(A1,FIND(":",A1)+7,10),MID(A1,FIND(":",A1)+9,10))

by **danjuma** » Mon Apr 05, 2010 6:57 pm

osknows wrote:you could put this in a MODULE
Code: Select all
Function Sp(cell As Range, count As Integer) Sp = Split(cell.Value, " ")(count) End Function

then in excel use the following formulae

=Sp(cell, word_count)

eg if "Hunt 5th Apr - 17:40 2m4f Hcap Chs" is in cell A1 then

=Sp(A1,0) Hunt
=Sp(A1,1) 5th
=Sp(A1,2) Apr
=Sp(A1,3) -
=Sp(A1,4) 17:40
=Sp(A1,5) 2m4f
etc

Oops! Looks like we posted about the same time. Thanks osknows. Your contribution and assistance in this forum is very much appreciated.

by **xraymitch** » Mon Apr 05, 2010 7:12 pm

Hi Guys,

Not sure if it adds anything to the debate but have a look at what I have done with data provided from knot.

I bow to osknows and his so much better and elegant solution. I really must start learning this VBA stuff

Thanks for sharing your expertise

Ray

by **xraymitch** » Mon Apr 05, 2010 7:14 pm

http://gruss-software.co.uk/forum/viewtopic.php?t=4719

Race Distance

Race Distance

Who is online

Sports betting software from Gruss Software