{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dataset","Manual Process","Apostrophe Operator","Ampersand Operator","TEXTJOIN Function","CONCAT Function","TEXT Function","RIGHT Function","Combination of REPT and LEN ","BASE Function","Table1","Power Query","VBA Macro","Remove Zeros","10 Digits Number"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee Record"]
[]
[null,"Name","ID"]
[null,"Lucas","112"]
[null,"Biden",12]
[null,"James",35]
[null,"John","5"]
[null,"Noah",21]
[null,"Julian","132"]

{"sheet":"Manual Process","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Leading Zeros Manually",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112","00112"]
[null,"Biden",12,"0012"]
[null,"James",35,"0035"]
[null,"John","5","005"]
[null,"Noah",21,"0021"]
[null,"Julian","132","00132"]

{"sheet":"Apostrophe Operator","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Leading Zeros Using Apostrophe Operator",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112","00112"]
[null,"Biden",12,"0012"]
[null,"James",35,"0035"]
[null,"John","5","005"]
[null,"Noah",21,"0021"]
[null,"Julian","132","00132"]

{"sheet":"Ampersand Operator","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Ampersand Operator",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"\"00\"&C5","v":"00112"},null,null,null,{"$f":"\"00\"&G5","v":"00"}]
[null,"Biden",12,{"$f":"\"00\"&C6","v":"0012"},null,null,null,{"$f":"\"00\"&G6","v":"00"}]
[null,"James",35,"0035",null,null,null,"00"]
[null,"John","5","005",null,null,null,"00"]
[null,"Noah",21,"0021",null,null,null,"00"]
[null,"Julian","132","00132",null,null,null,"00"]

{"sheet":"TEXTJOIN Function","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",C5)","v":"00112"},null,null,null,{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",G5)","v":"00"}]
[null,"Biden",12,{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",C6)","v":"0012"},null,null,null,{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",G6)","v":"00"}]
[null,"James",35,"0035",null,null,null,"00"]
[null,"John","5",{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",C8)","v":"005"},null,null,null,{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",G8)","v":"00"}]
[null,"Noah",21,"0021",null,null,null,{"$f":"_xlfn.TEXTJOIN( ,TRUE,\"00\",G9)","v":"00"}]
[null,"Julian","132","00132",null,null,null,"00"]

{"sheet":"CONCAT Function","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using CONCAT Function",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"_xlfn.CONCAT(\"00\",C5)","v":"00112"},null,null,null,{"$f":"_xlfn.CONCAT(\"00\",G5)","v":"00"}]
[null,"Biden",12,{"$f":"_xlfn.CONCAT(\"00\",C6)","v":"0012"},null,null,null,{"$f":"_xlfn.CONCAT(\"00\",G6)","v":"00"}]
[null,"James",35,"0035",null,null,null,"00"]
[null,"John","5","005",null,null,null,"00"]
[null,"Noah",21,"0021",null,null,null,"00"]
[null,"Julian","132","00132",null,null,null,"00"]

{"sheet":"TEXT Function","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using TEXT Function",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"TEXT(C5,\"00000\")","v":"00112"},null,null,null,{"$f":"TEXT(G5,\"00000\")","v":"00000"}]
[null,"Biden",12,{"$f":"TEXT(C6,\"00000\")","v":"00012"},null,null,null,{"$f":"TEXT(G6,\"00000\")","v":"00000"}]
[null,"James",35,"00035",null,null,null,"00000"]
[null,"John","5","00005",null,null,null,"00000"]
[null,"Noah",21,"00021",null,null,null,"00000"]
[null,"Julian","132","00132",null,null,null,"00000"]

{"sheet":"RIGHT Function","index":7,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using RIGHT Function",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"RIGHT(\"0000\"&C5,5)","v":"00112"},null,null,null,{"$f":"RIGHT(\"0000\"&G5,5)","v":"0000"}]
[null,"Biden",12,{"$f":"RIGHT(\"0000\"&C6,5)","v":"00012"},null,null,null,{"$f":"RIGHT(\"0000\"&G6,5)","v":"0000"}]
[null,"James",35,"00035",null,null,null,"0000"]
[null,"John","5","00005",null,null,null,"0000"]
[null,"Noah",21,"00021",null,null,null,"0000"]
[null,"Julian","132","00132",null,null,null,"0000"]

{"sheet":"Combination of REPT and LEN ","index":8,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Combination of REPT and LEN Functions",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"REPT(0,5-LEN(C5))&C5","v":"00112"},null,null,null,{"$f":"REPT(0,5-LEN(G5))&G5","v":"00000"}]
[null,"Biden",12,{"$f":"REPT(0,5-LEN(C6))&C6","v":"00012"},null,null,null,{"$f":"REPT(0,5-LEN(G6))&G6","v":"00000"}]
[null,"James",35,"00035",null,null,null,"00000"]
[null,"John","5","00005",null,null,null,"00000"]
[null,"Noah",21,"00021",null,null,null,"00000"]
[null,"Julian","132","00132",null,null,null,"00000"]

{"sheet":"BASE Function","index":9,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using BASE Function",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"_xlfn.BASE(C5,10,5)","v":"00112"},null,null,null,{"$f":"_xlfn.BASE(G5,10,5)","v":"00000"}]
[null,"Biden",12,{"$f":"_xlfn.BASE(C6,10,5)","v":"00012"},null,null,null,{"$f":"_xlfn.BASE(G6,10,5)","v":"00000"}]
[null,"James",35,"00035",null,null,null,"00000"]
[null,"John","5","00005",null,null,null,"00000"]
[null,"Noah",21,"00021",null,null,null,"00000"]
[null,"Julian","132","00132",null,null,null,"00000"]

{"sheet":"Table1","index":10,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Name","ID","ID with Leading Zeros"]
["Lucas","112","00112"]
["Biden","12","00012"]
["James","35","00035"]
["John","5","00005"]
["Noah","21","00021"]
["Julian","132","00132"]

{"sheet":"Power Query","index":11,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query"]
[]
[null,"Name","ID"]
[null,"Lucas","112"]
[null,"Biden",12]
[null,"James",35]
[null,"John","5"]
[null,"Noah",21]
[null,"Julian","132"]

{"sheet":"VBA Macro","index":12,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using VBA Macro",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112","00112"]
[null,"Biden",12,"00012"]
[null,"James",35,"00035"]
[null,"John","5","00005"]
[null,"Noah",21,"00021"]
[null,"Julian","132","00132"]

{"sheet":"Remove Zeros","index":13,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Removing Leading Zeros",null,null,null,"Practice Section"]
[]
[null,"Name","ID with Leading Zeros","ID After Removing Leading Zeros",null,"Name","ID with Leading Zeros","ID After Removing Leading Zeros"]
[null,"Lucas","00112",{"$f":"VALUE(C5)","v":112},null,null,null,{"$f":"VALUE(G5)","v":0}]
[null,"Biden","0012",{"$f":"VALUE(C6)","v":12},null,null,null,{"$f":"VALUE(G6)","v":0}]
[null,"James","0035",35,null,null,null,0]
[null,"John","005",5,null,null,null,0]
[null,"Noah","0021",21,null,null,null,0]
[null,"Julian","00132",132,null,null,null,0]

{"sheet":"10 Digits Number","index":14,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Leading Zeros to Make 10 Digits",null,null,null,"Practice Section"]
[]
[null,"Name","ID","ID with Leading Zeros",null,"Name","ID","ID with Leading Zeros"]
[null,"Lucas","112",{"$f":"_xlfn.BASE(C5,10,10)","v":"0000000112"},null,null,null,{"$f":"_xlfn.BASE(G5,10,10)","v":"0000000000"}]
[null,"Biden",12,{"$f":"_xlfn.BASE(C6,10,10)","v":"0000000012"},null,null,null,{"$f":"_xlfn.BASE(G6,10,10)","v":"0000000000"}]
[null,"James",35,"0000000035",null,null,null,"0000000000"]
[null,"John","5","0000000005",null,null,null,"0000000000"]
[null,"Noah",21,"0000000021",null,null,null,"0000000000"]
[null,"Julian","132",{"$f":"_xlfn.BASE(C10,10,10)","v":"0000000132"},null,null,null,{"$f":"_xlfn.BASE(G10,10,10)","v":"0000000000"}]