Return Race distance

[Kryten]

Hi Guys,

Does anyone know if there's a way of getting the current race distance into a cell in Excel. Preferably in furlongs, but if not then in any numerical foramat.

Cheers

[mak]

use the following 2 formulas
cell bt1
=IF(MID(A1,FIND(":",A1)+6,1)=" ",MID(A1,FIND(":",A1)+4,2),MID(A1,FIND(":",A1)+4,4))

cell bt2
=IF(TYPE(FIND("m",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("f",BT1)+1)*1,IF(TYPE(FIND("f",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("m",BT1)+1)*8,LEFT(BT1,FIND("m",BT1)-1)*8+MID(BT1,FIND("m",BT1)+1,FIND("f",BT1)-FIND("m",BT1)*1-1)))

in bt2 you will get furlongs

i think it is Gary's formula

[Kryten]

Thanks Mak!