{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Format Cells","Text Format","TEXT Function","Apostrophe Sign","RIGHT Function","BASE Function","PadText Function","Contact number","REPT and LEN Functions","VBA Code","DAX Formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Format Cells","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Format Cells"]
[]
[null,"Employee Name","Contact Number"]
[null,"John",7896246]
[null,"Thomas",2463741]
[null,"Nick",249981]
[null,"Robertson",112736458]
[null,"Ashley",7836004]
[null,"Benjamin",7796841]
[null,"Lucas",223347]

{"sheet":"Text Format","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Text Format"]
[]
[null,"Employee Name","Contact Number"]
[null,"John","0007896246"]
[null,"Thomas","0002463741"]
[null,"Nick","0000249981"]
[null,"Robertson","0112736458"]
[null,"Ashley","0007836004"]
[null,"Benjamin","0007796841"]
[null,"Lucas","0000223347"]

{"sheet":"TEXT Function","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of TEXT Function"]
[]
[null,"Employee Name","Contact Number",null,"Final Output"]
[null,"John",7896246,null,{"$f":"TEXT(C5,\"0000000000\")","v":"0007896246"}]
[null,"Thomas",2463741,null,{"$f":"TEXT(C6,\"0000000000\")","v":"0002463741"}]
[null,"Nick",249981,null,"0000249981"]
[null,"Robertson",112736458,null,"0112736458"]
[null,"Ashley",7836004,null,"0007836004"]
[null,"Benjamin",7796841,null,"0007796841"]
[null,"Lucas",223347,null,"0000223347"]

{"sheet":"Apostrophe Sign","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Apostrophe Sign"]
[]
[null,"Employee Name","Contact Number"]
[null,"John","0007896246"]
[null,"Thomas","0002463741"]
[null,"Nick","0000249981"]
[null,"Robertson","0112736458"]
[null,"Ashley","0007836004"]
[null,"Benjamin","0007796841"]
[null,"Lucas","0000223347"]

{"sheet":"RIGHT Function","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of RIGHT Function"]
[]
[null,"Employee Name","Contact Number",null,"Final Output"]
[null,"John",7896246,null,{"$f":"RIGHT(\"0000000000\"&C5,10)","v":"0007896246"}]
[null,"Thomas",2463741,null,{"$f":"RIGHT(\"0000000000\"&C6,10)","v":"0002463741"}]
[null,"Nick",249981,null,"0000249981"]
[null,"Robertson",112736458,null,"0112736458"]
[null,"Ashley",7836004,null,"0007836004"]
[null,"Benjamin",7796841,null,"0007796841"]
[null,"Lucas",223347,null,"0000223347"]

{"sheet":"BASE Function","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of BASE Function"]
[]
[null,"Employee Name","Contact Number",null,"Final Output"]
[null,"John",7896246,null,{"$f":"_xlfn.BASE(C5,10,10)","v":"0007896246"}]
[null,"Thomas",2463741,null,{"$f":"_xlfn.BASE(C6,10,10)","v":"0002463741"}]
[null,"Nick",249981,null,"0000249981"]
[null,"Robertson",112736458,null,"0112736458"]
[null,"Ashley",7836004,null,"0007836004"]
[null,"Benjamin",7796841,null,"0007796841"]
[null,"Lucas",223347,null,"0000223347"]

{"sheet":"PadText Function","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Query Option and PadText Function"]
[]
[null,"Employee Name","Contact Number"]
[null,"John",7896246]
[null,"Thomas",2463741]
[null,"Nick",249981]
[null,"Robertson",112736458]
[null,"Ashley",7836004]
[null,"Benjamin",7796841]
[null,"Lucas",223347]

{"sheet":"Contact number","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Column1","Contact number"]
["Contact Number","Contact Number"]
["7896246","0007896246"]
["2463741","0002463741"]
["249981","0000249981"]
["112736458","0112736458"]
["7836004","0007836004"]
["7796841","0007796841"]
["223347","0000223347"]

{"sheet":"REPT and LEN Functions","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combination of REPT and LEN Functions"]
[]
[null,"Employee Name","Contact Number",null,"Final Output"]
[null,"John",7896246,null,{"$f":"REPT(0,10-LEN(C5))&C5","v":"0007896246"}]
[null,"Thomas",2463741,null,{"$f":"REPT(0,10-LEN(C6))&C6","v":"0002463741"}]
[null,"Nick",249981,null,"0000249981"]
[null,"Robertson",112736458,null,"0112736458"]
[null,"Ashley",7836004,null,"0007836004"]
[null,"Benjamin",7796841,null,"0007796841"]
[null,"Lucas",223347,null,"0000223347"]

{"sheet":"VBA Code","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Employee Name","Contact Number"]
[null,"John",7896246]
[null,"Thomas",2463741]
[null,"Nick",249981]
[null,"Robertson",112736458]
[null,"Ashley",7836004]
[null,"Benjamin",7796841]
[null,"Lucas",223347]

{"sheet":"DAX Formula","index":10,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of DAX Formula"]
[]
[null,"Employee Name","Contact Number",null,null,"Contacts"]
[null,"John",7896246,null,null,"0007896246,0002463741,0000249981,0112736458,0007836004,0007796841,0000223347"]
[null,"Thomas",2463741]
[null,"Nick",249981]
[null,"Robertson",112736458]
[null,"Ashley",7836004]
[null,"Benjamin",7796841]
[null,"Lucas",223347]