{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","CONCAT","CONCATENATE","TEXTJOIN","Ampersand","Flash Fill","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":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employee List of ABC Company"]
[]
[null,"First Name","Last Name"]
[null,"Christian","Thomas"]
[null,"Eli","Harris"]
[null,"Ian","Schultz"]
[null,"Kimberly","Cruz"]
[null,"Kate","Watson"]
[null,"Kylie","Green"]
[null,"Brian","Reyes"]
[null,"Wyatt","Hale"]
[null,"Demi","Cox"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"CONCAT","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using CONCAT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"Christian Thomas"},null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Eli Harris"},null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]

{"sheet":"CONCATENATE","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Utilizing CONCATENATE Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Christian Thomas"},null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Eli Harris"},null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]

{"sheet":"TEXTJOIN","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Applying TEXTJOIN Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5,C5)","v":"Christian Thomas"},null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6,C6)","v":"Eli Harris"},null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]

{"sheet":"Ampersand","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Employing Ampersand Operator",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas",{"$f":"B5&\" \"&C5","v":"Christian Thomas"},null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris",{"$f":"B6&\" \"&C6","v":"Eli Harris"},null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]

{"sheet":"Flash Fill","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Utilizing Flash Fill Feature",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas","Christian Thomas",null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris","Eli Harris",null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]

{"sheet":"VBA","index":6,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Incorporating VBA Macro Option",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Christian","Thomas","Christian Thomas",null,null,null,null,null,null,"Christian","Thomas"]
[null,"Eli","Harris","Eli Harris",null,null,null,null,null,null,"Eli","Harris"]
[null,"Ian","Schultz","Ian Schultz",null,null,null,null,null,null,"Ian","Schultz"]
[null,"Kimberly","Cruz","Kimberly Cruz",null,null,null,null,null,null,"Kimberly","Cruz"]
[null,"Kate","Watson","Kate Watson",null,null,null,null,null,null,"Kate","Watson"]
[null,"Kylie","Green","Kylie Green",null,null,null,null,null,null,"Kylie","Green"]
[null,"Brian","Reyes","Brian Reyes",null,null,null,null,null,null,"Brian","Reyes"]
[null,"Wyatt","Hale","Wyatt Hale",null,null,null,null,null,null,"Wyatt","Hale"]
[null,"Demi","Cox","Demi Cox",null,null,null,null,null,null,"Demi","Cox"]