{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Career","Starts","Wins","2nd","3rd"]
["25:8-4-3.",{"$f":"--TRIM(REPLACE(A2,FIND(\":\",A2),255,\"\"))","v":25},{"$f":"IF(A2=\"\",\"\",--TRIM(LEFT(SUBSTITUTE(A2,B2&\":\",\"\"),FIND(\"-\",SUBSTITUTE(A2,B2&\":\",\"\"))-1)))","v":8},{"$f":"IF(A2=\"\",\"\",--TRIM(MID(A2,FIND(\"-\",A2)+1,(FIND(\"-\",A2,FIND(\"-\",A2)+1)-(FIND(\"-\",A2)+1)))))","v":4},{"$f":"IF(A2=\"\",\"\",--TRIM(MID(A2,FIND(\"-\",A2,FIND(\"-\",A2)+1)+1,255)))","v":3},{"$nulls":4},"Mate this getting to 70 sucks...."]
["67:15-11-4.",{"$f":"--TRIM(REPLACE(A3,FIND(\":\",A3),255,\"\"))","v":67},{"$f":"IF(A3=\"\",\"\",--TRIM(LEFT(SUBSTITUTE(A3,B3&\":\",\"\"),FIND(\"-\",SUBSTITUTE(A3,B3&\":\",\"\"))-1)))","v":15},{"$f":"IF(A3=\"\",\"\",--TRIM(MID(A3,FIND(\"-\",A3)+1,(FIND(\"-\",A3,FIND(\"-\",A3)+1)-(FIND(\"-\",A3)+1)))))","v":11},{"$f":"IF(A3=\"\",\"\",--TRIM(MID(A3,FIND(\"-\",A3,FIND(\"-\",A3)+1)+1,255)))","v":4},null,"l've tried yours ..replaced the colon in formula ..and this is the result...sorry to be a pain but can you fix it please"]
["69:11-9-8.",{"$f":"--TRIM(REPLACE(A4,FIND(\":\",A4),255,\"\"))","v":69},11,9,8,{"$nulls":4},"green should be 1"]
[{"$nulls":12},"shame l'm not 18yr would be able to do the excel and programming course..."]
[{"$nulls":9},"green should be 4",null,null,null,"well depends on brain..."]
[null,null,null,"This in D42",{"$nulls":7},"This inL42","This in M42","This in N42","This in O42"]
[{"$nulls":11},"Career-strt","win","2nd","3rd"]
[1,"02136x","REVEL IN GLORY","17-2-1-4",27952,"K HICKMOTT","SAMUEL PAYNE",2,1,null,null,{"$f":"--TRIM(REPLACE(D9,FIND(\"-\",D9),255,\"\"))","v":17},{"$f":"IF(D9=\"\",\"\",--TRIM(LEFT(SUBSTITUTE(D9,L9&\"-\",\"\"),FIND(\"-\",SUBSTITUTE(D9,L9&\"-\",\"\"))-1)))","v":2},{"$f":"IF(D9=\"\",\"\",--TRIM(MID(D9,FIND(\"-\",D9)+1,(FIND(\"-\",D9,FIND(\"-\",D9)+1)-(FIND(\"-\",D9)+1)))))","v":2},{"$f":"IF(D9=\"\",\"\",--TRIM(MID(D9,FIND(\"-\",D9,FIND(\"-\",D9)+1)+1,255)))","v":41365}]
[2,198834,"ROUSSOS DESTINY","19-2-3-2",36775,"K HICKMOTT","TRAVIS WOLFGRAM",10,2,null,null,{"$f":"--TRIM(REPLACE(D10,FIND(\"-\",D10),255,\"\"))","v":19},{"$f":"IF(D10=\"\",\"\",--TRIM(LEFT(SUBSTITUTE(D10,L10&\"-\",\"\"),FIND(\"-\",SUBSTITUTE(D10,L10&\"-\",\"\"))-1)))","v":2},{"$f":"IF(D10=\"\",\"\",--TRIM(MID(D10,FIND(\"-\",D10)+1,(FIND(\"-\",D10,FIND(\"-\",D10)+1)-(FIND(\"-\",D10)+1)))))","v":2},{"$f":"IF(D10=\"\",\"\",--TRIM(MID(D10,FIND(\"-\",D10,FIND(\"-\",D10)+1)+1,255)))","v":41308}]
[3,158782,"SILENT CREEK","33-6-2-4",53365,"B D BELLAMY","M BENNETT",4,3,null,null,33,6,6,41366]
[4,"x09571","UNTOUCHABLE ADAM","22-3-3-1",30725,"B D BELLAMY","R SPOKES",7,4,null,null,22,3,3,41277]
[5,"90x355","EPIC FAITH","16-2-1-4",18800,"M J DUNN","C WHITELEY",1,5,null,null,16,2,2,41365]
[6,104870,"KINGS DANSEUR","60-6-5-5",52600,"S J RANDALL","T TREICHEL",5,6,null,null,60,6,6,41399]
[7,"x38001","RED CELTIQUE","31-3-2-5",28050,"P J CUNNINGHAM","J L TAYLOR",9,7,null,null,31,3,3,41396]
[8,"xx45xx","BAIL ME OUT","48-2-2-4",25700,"D J WILCOCK","MS P SCHMIDT",8,8,null,null,48,2,2,41366]
[9,"x3x662","COASTAL","21-1-2-3",16775,"MS M THEXTON","ANTHONY ALLEN",3,9,null,null,21,1,1,41335]
[10,"26x698","JOH THE PAINTER","25-1-4-3",17300,"M A PALMER","UNKNOWN",6,10,null,null,25,1,1,41337]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}