{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data Set","RIGHT Function"," REPLACE Function","VBA Code 1","RIGHT and LEN Functions","REPLACE, LEFT, FIND & TRIM Func","FIND, MID, TRIM & LEN Functions","VBA Code 2"],"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 Set","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Name"]
[null,"101David"]
[null,"102Shaun"]
[null,"103Rodri"]
[null,"104James"]

{"sheet":"RIGHT Function","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Name"]
[null,"101David",{"$f":"RIGHT(B6,5)","v":"David"}]
[null,"102Shaun",{"$f":"RIGHT(B7,5)","v":"Shaun"}]
[null,"103Rodri","Rodri"]
[null,"104James","James"]

{"sheet":" REPLACE Function","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Numbers to Trim","Name"]
[null,"101David",3,{"$f":"REPLACE(B6,1,C6,\"\")","v":"David"}]
[null,"102Shaun",3,{"$f":"REPLACE(B7,1,C7,\"\")","v":"Shaun"}]
[null,"103Rodri",3,"Rodri"]
[null,"104James",3,"James"]

{"sheet":"VBA Code 1","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Name"]
[null,"101David"]
[null,"102Shaun"]
[null,"103Rodri"]
[null,"104James"]

{"sheet":"RIGHT and LEN Functions","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Numbers to Trim","Name"]
[null,"101David",3,{"$f":"RIGHT(B6,LEN(B6)-C6)","v":"David"}]
[null,"102Shaun",3,{"$f":"RIGHT(B7,LEN(B7)-C7)","v":"Shaun"}]
[null,"103Rodri",3,"Rodri"]
[null,"104James",3,"James"]

{"sheet":"REPLACE, LEFT, FIND & TRIM Func","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Name"]
[null,"   101 David",{"$f":"MID(B6,FIND(MID(TRIM(B6),1,1),B6),LEN(B6))","v":"101 David"}]
[null,"     102 Shaun",{"$f":"MID(B7,FIND(MID(TRIM(B7),1,1),B7),LEN(B7))","v":"102 Shaun"}]
[null,"      103 Rodri","103 Rodri"]
[null,"104 James","104 James"]

{"sheet":"FIND, MID, TRIM & LEN Functions","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null," Students Data"]
[]
[null,"ID","Name"]
[null,"     101 David",{"$f":"REPLACE(B6,1,FIND(LEFT(TRIM(B6),2),B6)-1,\"\")","v":"101 David"}]
[null,"102 Shaun",{"$f":"REPLACE(B7,1,FIND(LEFT(TRIM(B7),2),B7)-1,\"\")","v":"102 Shaun"}]
[null,"    103 Rodri","103 Rodri"]
[null,"    104 James","104 James"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"repl","v":{"$error":"#NAME?"}}]

{"sheet":"VBA Code 2","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Students Data"]
[]
[null,"ID"]
[null,"101David"]
[null,"102Shaun"]
[null,"103Rodri"]
[null,"104James"]