{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Dataset","Ampersand","CONCAT Function","CONCATENATE Function","CHAR, and TEXT with Ampersand","TEXTJOIN Function","VBA Macro Code"],"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":"Overview","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2],[18,2,19,2],[18,1,19,1]]}
[]
[null,"Concatenating Apostrophe"]
[]
[null,"First Name","Last Name"]
[null,"Jane","Doe"]
[null,"Kit","Harington"]
[null,"Jane","Austin"]
[null,"Julia","Roberts"]
[null,"Andrew","Eric"]
[null,"Bob","Harly"]
[null,"Rocky","Montana"]
[null,"Jay","Hope"]
[null,"Jony","Wilson"]
[]
[null,"Full Name","Formula"]
[null,{"$f":"\"'\"&B5&\"'\"&\" '\"&C5&\"'\"","v":"'Jane' 'Doe'"},{"$f":"_xlfn.FORMULATEXT(B16)","v":"=\"'\"&B5&\"'\"&\" '\"&C5&\"'\""}]
[null,{"$f":"_xlfn.CONCAT(\"'\",B5,\"'\",\" '\",C5,\"'\")","v":"'Jane' 'Doe'"},{"$f":"_xlfn.FORMULATEXT(B17)","v":"=CONCAT(\"'\",B5,\"'\",\" '\",C5,\"'\")"}]
[null,{"$f":"CONCATENATE(\"'\",B5,\"'\",\" '\",C5,\"'\")","v":"'Jane' 'Doe'"},"=CONCATENATE(\"'\",B5,\"'\",\" '\",C5,\"'\")"]
[null,{"$f":"CHAR(39)&TEXT(B5,\"\")&CHAR(39)&\" \"&CHAR(39)&TEXT(C5,\"\")&CHAR(39)","v":"'Jane' 'Doe'"},"=CHAR(39)&TEXT(B5,\"\")&CHAR(39)&\" \"&CHAR(39)&TEXT(C5,\"\")&CHAR(39)"]
[]
[null,{"$f":"\"'\"&_xlfn.TEXTJOIN(\"' '\",TRUE,B5,C5)&\"'\"","v":"'Jane' 'Doe'"},"=\"'\"&TEXTJOIN(\"' '\",TRUE,B5,C5)&\"'\""]

{"sheet":"Dataset","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Employee Name"]
[]
[null,"First Name","Last Name"]
[null,"Jane","Doe"]
[null,"Kit","Harington"]
[null,"Jane","Austin"]
[null,"Julia","Roberts"]
[null,"Andrew","Eric"]
[null,"Bob","Harly"]
[null,"Rocky","Montana"]
[null,"Jay","Hope"]
[null,"Jony","Wilson"]

{"sheet":"Ampersand","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,"Using 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,"Jane","Doe",{"$f":"\"'\"&B5&\"'\"&\" '\"&C5&\"'\"","v":"'Jane' 'Doe'"},null,null,null,null,null,null,"Jane","Doe"]
[null,"Kit","Harington",{"$f":"\"'\"&B6&\"'\"&\" '\"&C6&\"'\"","v":"'Kit' 'Harington'"},null,null,null,null,null,null,"Kit","Harington"]
[null,"Jane","Austin","'Jane' 'Austin'",null,null,null,null,null,null,"Jane","Austin"]
[null,"Julia","Roberts","'Julia' 'Roberts'",null,null,null,null,null,null,"Julia","Roberts"]
[null,"Andrew","Eric","'Andrew' 'Eric'",null,null,null,null,null,null,"Andrew","Eric"]
[null,"Bob","Harly","'Bob' 'Harly'",null,null,null,null,null,null,"Bob","Harly"]
[null,"Rocky","Montana","'Rocky' 'Montana'",null,null,null,null,null,null,"Rocky","Montana"]
[null,"Jay","Hope","'Jay' 'Hope'",null,null,null,null,null,null,"Jay","Hope"]
[null,"Jony","Wilson","'Jony' 'Wilson'",null,null,null,null,null,null,"Jony","Wilson"]

{"sheet":"CONCAT Function","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,"Utilizing CONCAT Function to Concatenate Apostrophe",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,"Jane","Doe",{"$f":"_xlfn.CONCAT(\"'\",B5,\"'\",\" '\",C5,\"'\")","v":"'Jane' 'Doe'"},null,null,null,null,null,null,"Jane","Doe"]
[null,"Kit","Harington",{"$f":"_xlfn.CONCAT(\"'\",B6,\"'\",\" '\",C6,\"'\")","v":"'Kit' 'Harington'"},null,null,null,null,null,null,"Kit","Harington"]
[null,"Jane","Austin","'Jane' 'Austin'",null,null,null,null,null,null,"Jane","Austin"]
[null,"Julia","Roberts","'Julia' 'Roberts'",null,null,null,null,null,null,"Julia","Roberts"]
[null,"Andrew","Eric","'Andrew' 'Eric'",null,null,null,null,null,null,"Andrew","Eric"]
[null,"Bob","Harly","'Bob' 'Harly'",null,null,null,null,null,null,"Bob","Harly"]
[null,"Rocky","Montana","'Rocky' 'Montana'",null,null,null,null,null,null,"Rocky","Montana"]
[null,"Jay","Hope","'Jay' 'Hope'",null,null,null,null,null,null,"Jay","Hope"]
[null,"Jony","Wilson","'Jony' 'Wilson'",null,null,null,null,null,null,"Jony","Wilson"]

{"sheet":"CONCATENATE Function","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,"Applying 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,"Jane","Doe",{"$f":"CONCATENATE(\"'\",B5,\"'\",\" '\",C5,\"'\")","v":"'Jane' 'Doe'"},null,null,null,null,null,null,"Jane","Doe"]
[null,"Kit","Harington",{"$f":"CONCATENATE(\"'\",B6,\"'\",\" '\",C6,\"'\")","v":"'Kit' 'Harington'"},null,null,null,null,null,null,"Kit","Harington"]
[null,"Jane","Austin","'Jane' 'Austin'",null,null,null,null,null,null,"Jane","Austin"]
[null,"Julia","Roberts","'Julia' 'Roberts'",null,null,null,null,null,null,"Julia","Roberts"]
[null,"Andrew","Eric","'Andrew' 'Eric'",null,null,null,null,null,null,"Andrew","Eric"]
[null,"Bob","Harly","'Bob' 'Harly'",null,null,null,null,null,null,"Bob","Harly"]
[null,"Rocky","Montana","'Rocky' 'Montana'",null,null,null,null,null,null,"Rocky","Montana"]
[null,"Jay","Hope","'Jay' 'Hope'",null,null,null,null,null,null,"Jay","Hope"]
[null,"Jony","Wilson","'Jony' 'Wilson'",null,null,null,null,null,null,"Jony","Wilson"]

{"sheet":"CHAR, and TEXT with Ampersand","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
[]
[null,"Implementing CHAR, and TEXT Functions with Ampersand Operator"]
[]
[null,"First Name","Last Name","Full Name"]
[]
[null,"Jane","Doe",{"$f":"CHAR(39)&TEXT(B6,\"\")&CHAR(39)&\" \"&CHAR(39)&TEXT(C6,\"\")&CHAR(39)","v":"'Jane' 'Doe'"}]
[null,"Kit","Harington",{"$f":"CHAR(39)&TEXT(B7,\"\")&CHAR(39)&\" \"&CHAR(39)&TEXT(C7,\"\")&CHAR(39)","v":"'Kit' 'Harington'"}]
[null,"Jane","Austin","'Jane' 'Austin'"]
[null,"Julia","Roberts","'Julia' 'Roberts'"]
[null,"Andrew","Eric","'Andrew' 'Eric'"]
[null,"Bob","Harly","'Bob' 'Harly'"]
[null,"Rocky","Montana","'Rocky' 'Montana'"]
[null,"Jay","Hope","'Jay' 'Hope'"]
[null,"Jony","Wilson","'Jony' 'Wilson'"]

{"sheet":"TEXTJOIN Function","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,"Using 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,"Jane","Doe",{"$f":"\"'\"&_xlfn.TEXTJOIN(\"' '\",TRUE,B5,C5)&\"'\"","v":"'Jane' 'Doe'"},null,null,null,null,null,null,"Jane","Doe"]
[null,"Kit","Harington",{"$f":"\"'\"&_xlfn.TEXTJOIN(\"' '\",TRUE,B6,C6)&\"'\"","v":"'Kit' 'Harington'"},null,null,null,null,null,null,"Kit","Harington"]
[null,"Jane","Austin","'Jane' 'Austin'",null,null,null,null,null,null,"Jane","Austin"]
[null,"Julia","Roberts","'Julia' 'Roberts'",null,null,null,null,null,null,"Julia","Roberts"]
[null,"Andrew","Eric","'Andrew' 'Eric'",null,null,null,null,null,null,"Andrew","Eric"]
[null,"Bob","Harly","'Bob' 'Harly'",null,null,null,null,null,null,"Bob","Harly"]
[null,"Rocky","Montana","'Rocky' 'Montana'",null,null,null,null,null,null,"Rocky","Montana"]
[null,"Jay","Hope","'Jay' 'Hope'",null,null,null,null,null,null,"Jay","Hope"]
[null,"Jony","Wilson","'Jony' 'Wilson'",null,null,null,null,null,null,"Jony","Wilson"]

{"sheet":"VBA Macro Code","index":7,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Incorporating VBA Macro Code",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe","'Jane' 'Doe'",null,null,null,null,null,null,null,"Jane","Doe"]
[null,"Kit","Harington","'Kit' 'Harington'",null,null,null,null,null,null,null,"Kit","Harington"]
[null,"Jane","Austin","'Jane' 'Austin'",null,null,null,null,null,null,null,"Jane","Austin"]
[null,"Julia","Roberts","'Julia' 'Roberts'",null,null,null,null,null,null,null,"Julia","Roberts"]
[null,"Andrew","Eric","'Andrew' 'Eric'",null,null,null,null,null,null,null,"Andrew","Eric"]
[null,"Bob","Harly","'Bob' 'Harly'",null,null,null,null,null,null,null,"Bob","Harly"]
[null,"Rocky","Montana","'Rocky' 'Montana'",null,null,null,null,null,null,null,"Rocky","Montana"]
[null,"Jay","Hope","'Jay' 'Hope'",null,null,null,null,null,null,null,"Jay","Hope"]
[null,"Jony","Wilson","'Jony' 'Wilson'",null,null,null,null,null,null,null,"Jony","Wilson"]