{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data Set","Adding Apostrophe","Ampersand","Custom Number","Text Format","CONCAT Function","RIGHT Function","TEXT Function","TEXTJOIN Function","BASE Function","REPT Function","VBA"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"Input","Output"]
[null,5]
[null,13]
[null,205]
[null,1004]
[null,45095]
[null,500068]

{"sheet":"Adding Apostrophe","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Adding Apostrohpe"]
[]
[null,"Input","Output"]
[null,5,"005"]
[null,13,"0013"]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]

{"sheet":"Ampersand","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Including Ampersand (&) Operator"]
[]
[null,"Input","Output"]
[null,5,{"$f":"\"00\"&B5","v":"005"}]
[null,13,{"$f":"\"00\"&B6","v":"0013"}]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]

{"sheet":"Custom Number","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Custom Number Format"]
[]
[null,"Input","Output"]
[null,5,5]
[null,13,13]
[null,205,205]
[null,1004,1004]
[null,45095,45095]
[null,500068,500068]

{"sheet":"Text Format","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Text Format"]
[]
[null,"Input","Output"]
[null,5,"005"]
[null,13,"0013"]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]

{"sheet":"CONCAT Function","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using CONCAT Function"]
[]
[null,"Input","Output"]
[null,5,{"$f":"_xlfn.CONCAT(\"00\",B5)","v":"005"}]
[null,13,{"$f":"_xlfn.CONCAT(\"00\",B6)","v":"0013"}]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]

{"sheet":"RIGHT Function","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing RIGHT Function"]
[]
[null,"Input","Output"]
[null,5,{"$f":"RIGHT(\"00\"&B5,3)","v":"005"}]
[null,13,{"$f":"RIGHT(\"00\"&B6,4)","v":"0013"}]
[null,205,{"$f":"RIGHT(\"00\"&B7,5)","v":"00205"}]
[null,1004,{"$f":"RIGHT(\"00\"&B8,6)","v":"001004"}]
[null,45095,{"$f":"RIGHT(\"00\"&B9,7)","v":"0045095"}]
[null,500068,{"$f":"RIGHT(\"00\"&B10,8)","v":"00500068"}]

{"sheet":"TEXT Function","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting TEXT Function"]
[]
[null,"Input","Output"]
[null,5,{"$f":"TEXT(B5,\"000\")","v":"005"}]
[null,13,{"$f":"TEXT(B6,\"0000\")","v":"0013"}]
[null,205,{"$f":"TEXT(B7,\"00000\")","v":"00205"}]
[null,1004,{"$f":"TEXT(B8,\"000000\")","v":"001004"}]
[null,45095,{"$f":"TEXT(B9,\"0000000\")","v":"0045095"}]
[null,500068,{"$f":"TEXT(B10,\"00000000\")","v":"00500068"}]

{"sheet":"TEXTJOIN Function","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"Input","Output"]
[null,5,{"$f":"_xlfn.TEXTJOIN(\"\",,\"00\",B5)","v":"005"}]
[null,13,{"$f":"_xlfn.TEXTJOIN(\"\",,\"00\",B6)","v":"0013"}]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]

{"sheet":"BASE Function","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying BASE Function"]
[]
[null,"Input","Output"]
[null,5,{"$f":"_xlfn.BASE(B5,10,3)","v":"005"}]
[null,13,{"$f":"_xlfn.BASE(B6,10,4)","v":"0013"}]
[null,205,{"$f":"_xlfn.BASE(B7,10,5)","v":"00205"}]
[null,1004,{"$f":"_xlfn.BASE(B8,10,6)","v":"001004"}]
[null,45095,{"$f":"_xlfn.BASE(B9,10,7)","v":"0045095"}]
[null,500068,{"$f":"_xlfn.BASE(B10,10,8)","v":"00500068"}]

{"sheet":"REPT Function","index":10,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting REPT Function "]
[]
[null,"Input","Output"]
[null,5,{"$f":"REPT(\"00\",1)&B5","v":"005"}]
[null,13,{"$f":"REPT(\"00\",1)&B6","v":"0013"}]
[null,205,"00205"]
[null,1004,"001004"]
[null,45095,"0045095"]
[null,500068,"00500068"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inserting REPT Function "]

{"sheet":"VBA","index":11,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Appyling VBA"]
[]
[null,"Input","Output"]
[null,5,5]
[null,13,13]
[null,205,205]
[null,1004,1004]
[null,45095,45095]
[null,500068,500068]