{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Ampersand","CONCAT Function","CONCATENATE Function","TEXT Function and 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":"Dataset","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"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":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Ampersand (&)"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"\"'\"&B4&\"'\"&\" '\"&C4&\"'\"","v":"'Jane' 'Doe'"}]
[null,"Kit","Harington",{"$f":"\"'\"&B5&\"'\"&\" '\"&C5&\"'\"","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":"CONCAT Function","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CONCAT Function"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"_xlfn.CONCAT(\"'\",B4,\"'\",\" '\",C4,\"'\")","v":"'Jane' 'Doe'"}]
[null,"Kit","Harington",{"$f":"_xlfn.CONCAT(\"'\",B5,\"'\",\" '\",C5,\"'\")","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":"CONCATENATE Function","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CONCATENATE Function"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"CONCATENATE(\"'\",B4,\"'\",\" '\",C4,\"'\")","v":"'Jane' 'Doe'"}]
[null,"Kit","Harington",{"$f":"CONCATENATE(\"'\",B5,\"'\",\" '\",C5,\"'\")","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":"TEXT Function and Ampersand","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Text Function and Ampersand (&)"]
[null,"First Name","First Name with Apostrophe","Last Name","Last Name with Apostrophe","Full Name"]
[null,"Jane",{"$f":"CHAR(39)&TEXT(B4,\"\")&CHAR(39)","v":"'Jane'"},"Doe",{"$f":"CHAR(39)&TEXT(D4,\"\")&CHAR(39)","v":"'Doe'"},{"$f":"C4&E4","v":"'Jane''Doe'"}]
[null,"Kit",{"$f":"CHAR(39)&TEXT(B5,\"\")&CHAR(39)","v":"'Kit'"},"Harington",{"$f":"CHAR(39)&TEXT(D5,\"\")&CHAR(39)","v":"'Harington'"},{"$f":"C5&E5","v":"'Kit''Harington'"}]
[null,"Jane","'Jane'","Austin","'Austin'","'Jane''Austin'"]
[null,"Julia","'Julia'","Roberts","'Roberts'","'Julia''Roberts'"]
[null,"Andrew","'Andrew'","Eric","'Eric'","'Andrew''Eric'"]
[null,"Bob","'Bob'","Harly","'Harly'","'Bob''Harly'"]
[null,"Rocky","'Rocky'","Montana","'Montana'","'Rocky''Montana'"]
[null,"Jay","'Jay'","Hope","'Hope'","'Jay''Hope'"]
[null,"Jony","'Jony'","Wilson","'Wilson'","'Jony''Wilson'"]

{"sheet":"TEXTJOIN Function","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using TEXTJOIN Function"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"_xlfn.TEXTJOIN(\"' '\",TRUE,B4,C4)","v":"Jane' 'Doe"}]
[null,"Kit","Harington",{"$f":"_xlfn.TEXTJOIN(\"' '\",TRUE,B5,C5)","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":"VBA Macro Code","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Macro Code"]
[null,"First Name","Last Name","Full Name"]
[null,"'Jane'","'Doe'",{"$f":"B4&C4","v":"'Jane''Doe'"}]
[null,"'Kit'","'Harington'",{"$f":"B5&C5","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'"]