{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","LEFT and LEN","VALUE, LEFT and LEN","VBA","TRIM","TEXT to Column"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Data","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,1]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Distance Covered"]
["Mark Buam","12.5 miles"]
["Antony Hoppers","14.7 miles"]
["Tim Jonshon","10.3 miles"]
["Harold Finch","12.8 miles"]
["Tomas Gray","13.4 miles"]

{"sheet":"LEFT and LEN","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,1]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Distance Covered","Distance Covered in Miles"]
["Mark Buam","12.5 miles",{"$f":"LEFT(B7,LEN(B7)-6)","v":"12.5"}]
["Antony Hoppers","14.7 miles",{"$f":"LEFT(B8,LEN(B8)-6)","v":"14.7"}]
["Tim Jonshon","10.3 miles","10.3"]
["Harold Finch","12.8 miles","12.8"]
["Tomas Gray","13.4 miles","13.4"]

{"sheet":"VALUE, LEFT and LEN","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,1]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Distance Covered","Distance Covered in Miles"]
["Mark Buam","12.5 miles",{"$f":"VALUE(LEFT(B7,LEN(B7)-6))","v":12.5}]
["Antony Hoppers","14.7 miles",{"$f":"VALUE(LEFT(B8,LEN(B8)-6))","v":14.7}]
["Tim Jonshon","10.3 miles",10.3]
["Harold Finch","12.8 miles",12.8]
["Tomas Gray","13.4 miles",{"$f":"VALUE(LEFT(B11,LEN(B11)-6))","v":13.4}]

{"sheet":"VBA","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,1]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Distance Covered","Distance Covered in Miles"]
["Mark Buam","12.5 miles",{"$f":"TRIMLASTX(B7,6)","v":"12.5"}]
["Antony Hoppers","14.7 miles",{"$f":"TRIMLASTX(B8,6)","v":"14.7"}]
["Tim Jonshon","10.3 miles",{"$f":"TRIMLASTX(B9,6)","v":"10.3"}]
["Harold Finch","12.8 miles",{"$f":"TRIMLASTX(B10,6)","v":"12.8"}]
["Tomas Gray","13.4 miles",{"$f":"TRIMLASTX(B11,6)","v":"13.4"}]

{"sheet":"TRIM","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,1]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Distance Covered","Removing Extra Spaces from the Right"]
["Mark Buam    ","12.5 miles",{"$f":"TRIM(A7)","v":"Mark Buam"}]
["Antony Hoppers  ","14.7 miles",{"$f":"TRIM(A8)","v":"Antony Hoppers"}]
["Tim Jonshon   ","10.3 miles",{"$f":"TRIM(A9)","v":"Tim Jonshon"}]
["Harold Finch     ","12.8 miles","Harold Finch"]
["Tomas Gray      ","13.4 miles","Tomas Gray"]

{"sheet":"TEXT to Column","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,0,3,2],[0,0,0,2]]}
["Trim Right Characters in Excel"]
[]
[]
["The Goldcup Marathon"]
[]
["Participant Name","Spare Column","Distance Covered"]
["Mark Buam",null,"12.5 miles"]
["Antony Hoppers",null,"14.7 miles"]
["Tim Jonshon",null,"10.3 miles"]
["Harold Finch",null,"12.8 miles"]
["Tomas Gray",null,"13.4 miles"]