{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Macro","User Defined Function","Last 3 Characters","First and Last Characters"],"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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Student Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID"]
[null,"Alfred Moyes","S20214576D"]
[null,"James Rosenburg","S20203377D"]
[null,"Angela Hopkins","S20213415D"]
[null,"Natalia Austin","S20196730D"]
[null,"Kane Orlando","S20215638D"]
[null,"Frank Orwell","S20181890D"]
[null,"Marcus North","S20194567D"]
[null,"Jennifer Marlo","S20206517D"]
[null,"Steve Smith","S20206510D"]
[null,"Desmond Hayes","S20213907D"]

{"sheet":"Macro","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Macro to Remove Last Character from String",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID",null,null,null,null,null,null,"Student Name","Student ID"]
[null,"Alfred Moyes","S20214576",null,null,null,null,null,null,"Alfred Moyes","S20214576D"]
[null,"James Rosenburg","S20203377",null,null,null,null,null,null,"James Rosenburg","S20203377D"]
[null,"Angela Hopkins","S20213415",null,null,null,null,null,null,"Angela Hopkins","S20213415D"]
[null,"Natalia Austin","S20196730",null,null,null,null,null,null,"Natalia Austin","S20196730D"]
[null,"Kane Orlando","S20215638",null,null,null,null,null,null,"Kane Orlando","S20215638D"]
[null,"Frank Orwell","S20181890",null,null,null,null,null,null,"Frank Orwell","S20181890D"]
[null,"Marcus North","S20194567",null,null,null,null,null,null,"Marcus North","S20194567D"]
[null,"Jennifer Marlo","S20206517",null,null,null,null,null,null,"Jennifer Marlo","S20206517D"]
[null,"Steve Smith","S20206510",null,null,null,null,null,null,"Steve Smith","S20206510D"]
[null,"Desmond Hayes","S20213907",null,null,null,null,null,null,"Desmond Hayes","S20213907D"]

{"sheet":"User Defined Function","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Utilizing User Defined Function to Remove Last Character",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID","Without Last Character",null,null,null,null,null,null,"Student Name","Student ID","Without Last Character"]
[null,"Alfred Moyes","S20214576D",{"$f":"REMOVELASTCHARACTER(C5:C14,1)","v":"S20214576"},null,null,null,null,null,null,"Alfred Moyes","S20214576D"]
[null,"James Rosenburg","S20203377D","S20203377",null,null,null,null,null,null,"James Rosenburg","S20203377D"]
[null,"Angela Hopkins","S20213415D","S20213415",null,null,null,null,null,null,"Angela Hopkins","S20213415D"]
[null,"Natalia Austin","S20196730D","S20196730",null,null,null,null,null,null,"Natalia Austin","S20196730D"]
[null,"Kane Orlando","S20215638D","S20215638",null,null,null,null,null,null,"Kane Orlando","S20215638D"]
[null,"Frank Orwell","S20181890D","S20181890",null,null,null,null,null,null,"Frank Orwell","S20181890D"]
[null,"Marcus North","S20194567D","S20194567",null,null,null,null,null,null,"Marcus North","S20194567D"]
[null,"Jennifer Marlo","S20206517D","S20206517",null,null,null,null,null,null,"Jennifer Marlo","S20206517D"]
[null,"Steve Smith","S20206510D","S20206510",null,null,null,null,null,null,"Steve Smith","S20206510D"]
[null,"Desmond Hayes","S20213907D","S20213907",null,null,null,null,null,null,"Desmond Hayes","S20213907D"]

{"sheet":"Last 3 Characters","index":3,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Removing Last 3 Characters Using VBA",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name","Student ID",null,null,null,null,null,null,"Student Name","Student ID"]
[null,"Alfred Moyes","S202145",null,null,null,null,null,null,"Alfred Moyes","S20214576D"]
[null,"James Rosenburg","S202033",null,null,null,null,null,null,"James Rosenburg","S20203377D"]
[null,"Angela Hopkins","S202134",null,null,null,null,null,null,"Angela Hopkins","S20213415D"]
[null,"Natalia Austin","S201967",null,null,null,null,null,null,"Natalia Austin","S20196730D"]
[null,"Kane Orlando","S202156",null,null,null,null,null,null,"Kane Orlando","S20215638D"]
[null,"Frank Orwell","S201818",null,null,null,null,null,null,"Frank Orwell","S20181890D"]
[null,"Marcus North","S201945",null,null,null,null,null,null,"Marcus North","S20194567D"]
[null,"Jennifer Marlo","S202065",null,null,null,null,null,null,"Jennifer Marlo","S20206517D"]
[null,"Steve Smith","S202065",null,null,null,null,null,null,"Steve Smith","S20206510D"]
[null,"Desmond Hayes","S202139",null,null,null,null,null,null,"Desmond Hayes","S20213907D"]

{"sheet":"First and Last Characters","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Deleting First and Last Characters Using VBA",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,20213907,"Student ID",null,null,null,null,null,null,"Student Name","Student ID"]
[null,"Alfred Moyes","S20214576",null,null,null,null,null,null,"Alfred Moyes","S20214576D"]
[null,"James Rosenburg","S20203377",null,null,null,null,null,null,"James Rosenburg","S20203377D"]
[null,"Angela Hopkins","S20213415",null,null,null,null,null,null,"Angela Hopkins","S20213415D"]
[null,"Natalia Austin","S20196730",null,null,null,null,null,null,"Natalia Austin","S20196730D"]
[null,"Kane Orlando","S20215638",null,null,null,null,null,null,"Kane Orlando","S20215638D"]
[null,"Frank Orwell","S20181890",null,null,null,null,null,null,"Frank Orwell","S20181890D"]
[null,"Marcus North","S20194567",null,null,null,null,null,null,"Marcus North","S20194567D"]
[null,"Jennifer Marlo","S20206517",null,null,null,null,null,null,"Jennifer Marlo","S20206517D"]
[null,"Steve Smith","S20206510",null,null,null,null,null,null,"Steve Smith","S20206510D"]
[null,"Desmond Hayes","S20213907",null,null,null,null,null,null,"Desmond Hayes","S20213907D"]