some excel help please
 

Could someone please help?

I was trying to download some form from the ozeform horse search database and have encountered a few problems that go beyond my excel abilities. The major problem is the finishing position and field numbers. For example 1/12
will come out as 1 December. I know that the columns need to be formatted but I cant seem to do it correctly. I would also like to split the two figures into seperate cells. Also with the beaten margin figure, if the horse has won the margin to the second horse comes up and as I am experimenting with the beaten margins I would like excel to turn the margin to zero if the horse has finished first. Thanking you in advance.

my email address is sonnyboy64 at optusnet dot com dot au


Happy new year to everyone on the forum and please drive safely tonite.

Hi Ron,

I can probably help you....I think.

If you want, send me an excel example and I'll give it a shot.

racestats at hotmail dot com.

I sent you an E-mail Dr Ron have done lots of work with the Oze Form site as well as cyberhorse site regarding this issue

Thanks guys, emails have just been sent.

DR RON,

I've sent you a workaround for this problem just now with an example.

Cheers.

Mind sending that to met Chrome would like to take a look
shaun2166@hotmail.com

Copy sent to you Shaun.

Cheers.

May i also get a copy Chrome
kewldude28 at hot mail dot com
Thanks in advance

Thanks chrome....i am new at excel and wanted see if what i was doing to extract information was correct....and it was according to your file....i also use this formula to extract information from cyber horse form

=TRIM(MID(A$2,FIND("&",SUBSTITUTE(A$2,",","&",B2))+1,FIND(",",REPLACE(A$2,1,FIND("&",SUBSTITUTE(A$2,",","&",B2)),""))-1))


where B2 has the amount of commas that you want to skip to and A2 contains the form line

Wow Shaun, you're obviously far more advanced than me at this.

My codes are very basic and you have got a much better grasp at getting the info "parsed".

Well done and thanks for the code.

I'll email you a workaround for Cyberhorse as well that may not require code.