{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RIGHT and LEN","MID and LEN","REPLACE","Flash Fill","Text to Column","Macro"],"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":"RIGHT and LEN","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes","S201678",{"$f":"RIGHT(C4,LEN(C4)-1)","v":"201678"}]
[null,"Angela Hokins","S211744",{"$f":"RIGHT(C5,LEN(C5)-1)","v":"211744"}]
[null,"Frank Orwell","S201093","201093"]
[null,"Desmond Hayes","S201380","201380"]
[null,"Jennifer Marlo","S201977","201977"]
[null,"Natalia Austin","S211164","211164"]
[null,"Richard Simpson","S221971","221971"]
[null,"Marcus North","S201688","201688"]
[null,"Steve Smith","S201921","201921"]
[null,"Kane Richardson","S231927","231927"]

{"sheet":"MID and LEN","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes","S201678",{"$f":"MID(C4,2,LEN(C4)-1)","v":"201678"}]
[null,"Angela Hokins","S211744",{"$f":"MID(C5,2,LEN(C5)-1)","v":"211744"}]
[null,"Frank Orwell","S201093","201093"]
[null,"Desmond Hayes","S201380","201380"]
[null,"Jennifer Marlo","S201977","201977"]
[null,"Natalia Austin","S211164","211164"]
[null,"Richard Simpson","S221971","221971"]
[null,"Marcus North","S201688","201688"]
[null,"Steve Smith","S201921","201921"]
[null,"Kane Richardson","S231927","231927"]

{"sheet":"REPLACE","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes","S201678",{"$f":"REPLACE(C4,1,1,\"\")","v":"201678"}]
[null,"Angela Hokins","S211744",{"$f":"REPLACE(C5,1,1,\"\")","v":"211744"}]
[null,"Frank Orwell","S201093","201093"]
[null,"Desmond Hayes","S201380","201380"]
[null,"Jennifer Marlo","S201977","201977"]
[null,"Natalia Austin","S211164","211164"]
[null,"Richard Simpson","S221971","221971"]
[null,"Marcus North","S201688","201688"]
[null,"Steve Smith","S201921","201921"]
[null,"Kane Richardson","S231927","231927"]

{"sheet":"Flash Fill","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes","S201678",201678]
[null,"Angela Hokins","S211744",211744]
[null,"Frank Orwell","S201093",201093]
[null,"Desmond Hayes","S201380",201380]
[null,"Jennifer Marlo","S201977",201977]
[null,"Natalia Austin","S211164",211164]
[null,"Richard Simpson","S221971",221971]
[null,"Marcus North","S201688",201688]
[null,"Steve Smith","S201921",201921]
[null,"Kane Richardson","S231927",231927]

{"sheet":"Text to Column","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes",201678]
[null,"Angela Hokins",211744]
[null,"Frank Orwell",201093]
[null,"Desmond Hayes",201380]
[null,"Jennifer Marlo",201977]
[null,"Natalia Austin",211164]
[null,"Richard Simpson",221971]
[null,"Marcus North",201688]
[null,"Steve Smith",201921]
[null,"Kane Richardson",231927]

{"sheet":"Macro","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes",201678]
[null,"Angela Hokins",211744]
[null,"Frank Orwell",201093]
[null,"Desmond Hayes",201380]
[null,"Jennifer Marlo",201977]
[null,"Natalia Austin",211164]
[null,"Richard Simpson",221971]
[null,"Marcus North",201688]
[null,"Steve Smith",201921]
[null,"Kane Richardson",231927]