{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Applying Text Format","Using Custom Format","Employ Apostrophe (’) ","Using TEXT Function","Apply Ampersand (&) Operatore","Employing CONCATENATE Function","Utilizing RIGHT Function","RIGHT and CONCATENATE Functions","Using BASE Function","CONCATENATE, REPT, and LEN ","Using 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":"Dataset","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Adding Leading Zeros"]
[]
[null,"Employee Name ","ID"]
[null,"Jack Morris",111]
[null,"Steve Gibbs",121]
[null,"Alen Moor",131]
[null,"Richard Hick",141]
[null,"Kevin Orwell",151]
[null,"Shane Jennings",161]
[null,"Natalia Austin",171]
[null,"Jennifar Marlo",181]
[null,"Mike Robbins",191]

{"sheet":"Applying Text Format","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Applying Text Format",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID",null,null,null,null,null,"Employee Name ","ID"]
[null,"Jack Morris","000111",null,null,null,null,null,"Jack Morris",111]
[null,"Steve Gibbs","000121",null,null,null,null,null,"Steve Gibbs",121]
[null,"Alen Moor","000131",null,null,null,null,null,"Alen Moor",131]
[null,"Richard Hick","000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell","000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings","000161",null,null,null,null,null,"Shane Jennings",161]
[null,"Natalia Austin","000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo","000181",null,null,null,null,null,"Jennifar Marlo",181]
[null,"Mike Robbins","000191",null,null,null,null,null,"Mike Robbins",191]

{"sheet":"Using Custom Format","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Custom Format",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID",null,null,null,null,null,"Employee Name ","ID"]
[null,"Jack Morris",111,null,null,null,null,null,"Jack Morris",111]
[null,"Steve Gibbs",121,null,null,null,null,null,"Steve Gibbs",121]
[null,"Alen Moor",131,null,null,null,null,null,"Alen Moor",131]
[null,"Richard Hick",141,null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",161,null,null,null,null,null,"Shane Jennings",161]
[null,"Natalia Austin",171,null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",181,null,null,null,null,null,"Jennifar Marlo",181]
[null,"Mike Robbins",191,null,null,null,null,null,"Mike Robbins",191]

{"sheet":"Employ Apostrophe (’) ","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Employing Apostrophe (')",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID",null,null,null,null,null,null,"Employee Name ","ID"]
[null,"Jack Morris","000111",null,null,null,null,null,null,"Jack Morris"]
[null,"Steve Gibbs","000121",null,null,null,null,null,null,"Steve Gibbs"]
[null,"Alen Moor","000131",null,null,null,null,null,null,"Alen Moor"]
[null,"Richard Hick","000141",null,null,null,null,null,null,"Richard Hick"]
[null,"Kevin Orwell","000151",null,null,null,null,null,null,"Kevin Orwell"]
[null,"Shane Jennings","000161",null,null,null,null,null,null,"Shane Jennings"]
[null,"Natalia Austin","000171",null,null,null,null,null,null,"Natalia Austin"]
[null,"Jennifar Marlo","000181",null,null,null,null,null,null,"Jennifar Marlo"]
[null,"Mike Robbins","000191",null,null,null,null,null,null,"Mike Robbins"]

{"sheet":"Using TEXT Function","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using TEXT Function",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",111,{"$f":"TEXT(C5,\"000000\")","v":"000111"},null,null,null,null,null,"Jack Morris",111]
[null,"Steve Gibbs",121,{"$f":"TEXT(C6,\"000000\")","v":"000121"},null,null,null,null,null,"Steve Gibbs",121]
[null,"Alen Moor",131,"000131",null,null,null,null,null,"Alen Moor",131]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",161,"000161",null,null,null,null,null,"Shane Jennings",161]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",181,"000181",null,null,null,null,null,"Jennifar Marlo",181]
[null,"Mike Robbins",191,"000191",null,null,null,null,null,"Mike Robbins",191]

{"sheet":"Apply Ampersand (&) Operatore","index":5,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Applying Ampersand (&) Operatore",null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",111,{"$f":"\"000\"&C5","v":"000111"},null,null,null,null,"Jack Morris",111]
[null,"Steve Gibbs",121,{"$f":"\"000\"&C6","v":"000121"},null,null,null,null,"Steve Gibbs",121]
[null,"Alen Moor",131,"000131",null,null,null,null,"Alen Moor",131]
[null,"Richard Hick",141,"000141",null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",161,"000161",null,null,null,null,"Shane Jennings",161]
[null,"Natalia Austin",171,"000171",null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",181,"000181",null,null,null,null,"Jennifar Marlo",181]
[null,"Mike Robbins",191,"000191",null,null,null,null,"Mike Robbins",191]

{"sheet":"Employing CONCATENATE Function","index":6,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Employing CONCATENATE Function",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",111,{"$f":"CONCATENATE(\"000\",C5)","v":"000111"},null,null,null,null,null,"Jack Morris",111]
[null,"Steve Gibbs",121,{"$f":"CONCATENATE(\"000\",C6)","v":"000121"},null,null,null,null,null,"Steve Gibbs",121]
[null,"Alen Moor",131,"000131",null,null,null,null,null,"Alen Moor",131]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",161,"000161",null,null,null,null,null,"Shane Jennings",161]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",181,"000181",null,null,null,null,null,"Jennifar Marlo",181]
[null,"Mike Robbins",191,"000191",null,null,null,null,null,"Mike Robbins",191]

{"sheet":"Utilizing RIGHT Function","index":7,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Utilizing RIGHT Function",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",11,{"$f":"RIGHT(\"00000\"&C5,6)","v":"000011"},null,null,null,null,null,"Jack Morris",11]
[null,"Steve Gibbs",21,{"$f":"RIGHT(\"00000\"&C6,6)","v":"000021"},null,null,null,null,null,"Steve Gibbs",21]
[null,"Alen Moor",1311,"001311",null,null,null,null,null,"Alen Moor",1311]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",16,"000016",null,null,null,null,null,"Shane Jennings",16]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",1181,"001181",null,null,null,null,null,"Jennifar Marlo",1181]
[null,"Mike Robbins",1910,"001910",null,null,null,null,null,"Mike Robbins",1910]

{"sheet":"RIGHT and CONCATENATE Functions","index":8,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using RIGHT and CONCATENATE Functions",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",11,{"$f":"RIGHT(CONCATENATE(\"00000\",C5),6)","v":"000011"},null,null,null,null,null,"Jack Morris",11]
[null,"Steve Gibbs",21,{"$f":"RIGHT(CONCATENATE(\"00000\",C6),6)","v":"000021"},null,null,null,null,null,"Steve Gibbs",21]
[null,"Alen Moor",1311,"001311",null,null,null,null,null,"Alen Moor",1311]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",16,"000016",null,null,null,null,null,"Shane Jennings",16]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",1181,"001181",null,null,null,null,null,"Jennifar Marlo",1181]
[null,"Mike Robbins",1910,"001910",null,null,null,null,null,"Mike Robbins",1910]

{"sheet":"Using BASE Function","index":9,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using BASE Function",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",11,{"$f":"_xlfn.BASE(C5,10,6)","v":"000011"},null,null,null,null,null,"Jack Morris",11]
[null,"Steve Gibbs",21,{"$f":"_xlfn.BASE(C6,10,6)","v":"000021"},null,null,null,null,null,"Steve Gibbs",21]
[null,"Alen Moor",1311,"001311",null,null,null,null,null,"Alen Moor",1311]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",16,"000016",null,null,null,null,null,"Shane Jennings",16]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",1181,"001181",null,null,null,null,null,"Jennifar Marlo",1181]
[null,"Mike Robbins",1910,"001910",null,null,null,null,null,"Mike Robbins",1910]

{"sheet":"CONCATENATE, REPT, and LEN ","index":10,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Employing CONCATENATE, REPT, and LEN Functions",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",11,{"$f":"CONCATENATE(REPT(0,6-LEN(C5)),C5)","v":"000011"},null,null,null,null,null,"Jack Morris",11]
[null,"Steve Gibbs",21,{"$f":"CONCATENATE(REPT(0,6-LEN(C6)),C6)","v":"000021"},null,null,null,null,null,"Steve Gibbs",21]
[null,"Alen Moor",1311,"001311",null,null,null,null,null,"Alen Moor",1311]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",16,"000016",null,null,null,null,null,"Shane Jennings",16]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",1181,"001181",null,null,null,null,null,"Jennifar Marlo",1181]
[null,"Mike Robbins",1910,"001910",null,null,null,null,null,"Mike Robbins",1910]

{"sheet":"Using VBA","index":11,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Employee Name ","ID","ID with Zero",null,null,null,null,null,"Employee Name ","ID","ID with Zero"]
[null,"Jack Morris",11,{"$f":"Add_Leading_Zeroes(C5,6)","v":"000011"},null,null,null,null,null,"Jack Morris",11]
[null,"Steve Gibbs",21,{"$f":"Add_Leading_Zeroes(C6,6)","v":"000021"},null,null,null,null,null,"Steve Gibbs",21]
[null,"Alen Moor",1311,"001311",null,null,null,null,null,"Alen Moor",1311]
[null,"Richard Hick",141,"000141",null,null,null,null,null,"Richard Hick",141]
[null,"Kevin Orwell",151,"000151",null,null,null,null,null,"Kevin Orwell",151]
[null,"Shane Jennings",16,"000016",null,null,null,null,null,"Shane Jennings",16]
[null,"Natalia Austin",171,"000171",null,null,null,null,null,"Natalia Austin",171]
[null,"Jennifar Marlo",1181,"001181",null,null,null,null,null,"Jennifar Marlo",1181]
[null,"Mike Robbins",1910,"001910",null,null,null,null,null,"Mike Robbins",1910]