excel formula may help someone
 

Got this of mrexcel, its a formula to grab the weight of the horse and change the fraction to decimal, thought someone might use it. The form was from racing and sports.

	B	C
2	LATEST MODEL Kerry Baumann(Townsville) 16 57 kg	57
3	RANMOORO (blks) Bob Purcell(Townsville) 17 57 kg	57
4	SUCCESSFUL JO Janel Ryan(Atherton) 4 56½ kg	56.5

Spreadsheet Formulas

Cell Formula C2 =VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B2,SEARCH(CHAR(160)&"kg",B2)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5")) C3 =VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B3,SEARCH(CHAR(160)&"kg",B3)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5")) C4 =VALUE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(B4,SEARCH(CHAR(160)&"kg",B4)-1),CHAR(160),REPT(" ",255)),255)),CHAR(189),".5"))