{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Concatenate","using ampersand","ampersand and CHAR","Transpose and concatenate","TODAY & TEXT","VBA","TEXTJOIN","Concatenate with delimiter"],"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":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"List of Names"]
[]
[null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Marshman"]
[null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole"]

{"sheet":"Concatenate","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"List of Names",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Middle Name","Last Name","Full Name",null,null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Marshman",{"$f":"CONCATENATE(B6,\" \",C6,\" \",D6)","v":"John Klerk Marshman"},null,null,"John","Klerk","Mershman"]
[null,"William","Darell"," Francis",{"$f":"CONCATENATE(B7,\" \",C7,\" \",D7)","v":"William Darell  Francis"},null,null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox","Maria  Snider Fox",null,null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper","Paul  Green Harper",null,null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole","Zelda Mandy  Cole",null,null,"Zelda","Mandy"," Cole"]

{"sheet":"using ampersand","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"List of Names",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Middle Name","Last Name","Full Name",null,null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Marshman",{"$f":"B6&\" \"&C6&\" \"&D6","v":"John Klerk Marshman"},null,null,"John","Klerk","Mershman"]
[null,"William","Darell"," Francis",{"$f":"B7&\" \"&C7&\" \"&D7","v":"William Darell  Francis"},null,null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox","Maria  Snider Fox",null,null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper","Paul  Green Harper",null,null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole","Zelda Mandy  Cole",null,null,"Zelda","Mandy"," Cole"]

{"sheet":"ampersand and CHAR","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"List of Names",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Middle Name","Last Name","Full Name",null,null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Marshman",{"$f":"B6&CHAR(32)&C6&CHAR(32)&D6","v":"John Klerk Marshman"},null,null,"John","Klerk","Mershman"]
[null,"William","Darell"," Francis",{"$f":"B7&CHAR(32)&C7&CHAR(32)&D7","v":"William Darell  Francis"},null,null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox","Maria  Snider Fox",null,null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper","Paul  Green Harper",null,null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole","Zelda Mandy  Cole",null,null,"Zelda","Mandy"," Cole"]

{"sheet":"Transpose and concatenate","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"List of Names",null,null,null,"Try yourself"]
[]
[null,"First Name","John",null,null,"First Name","John"]
[null,"Middle Name","Klerk",null,null,"Middle Name","Klerk"]
[null,"Last Name","Marshman",null,null,"Last Name","Marshman"]
[]
[null,"Full Name",{"$f":"CONCATENATE(\"John \",\"Klerk \",\"Marshman \")","v":"John Klerk Marshman "},null,null,"Full Name"]

{"sheet":"TODAY & TEXT","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Date ",null,null,null,null,"Try Yourself"]
[]
[null,"Date","Date Format","Output",null,null,"Date","Date Format","Output"]
[null,{"$f":"TODAY()","v":"2023-01-12"},{"$f":"\"Today is \"&TODAY()","v":"Today is 44938"},{"$f":"\"Today is \"&TEXT(TODAY(),\"mm-dd-yy\")","v":"Today is 01-12-23"}]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"List of Names",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Middle Name","Last Name","Full Name",null,null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Mershman",{"$f":"ConcatenateA(B6:D6)","v":"John Klerk Mershman"},null,null,"John","Klerk","Mershman"]
[null,"William","Darell"," Francis",{"$f":"ConcatenateA(B7:D7)","v":"William Darell  Francis"},null,null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox",{"$f":"ConcatenateA(B8:D8)","v":"Maria  Snider Fox"},null,null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper",{"$f":"ConcatenateA(B9:D9)","v":"Paul  Green Harper"},null,null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole",{"$f":"ConcatenateA(B10:D10)","v":"Zelda Mandy  Cole"},null,null,"Zelda","Mandy"," Cole"]

{"sheet":"TEXTJOIN","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"List of Names",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Middle Name","Last Name","Full Name",null,null,"First Name","Middle Name","Last Name","Full Name"]
[null,"John","Klerk","Mershman",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6:D6)","v":"John Klerk Mershman"},null,null,"John","Klerk","Mershman"]
[null,"William","Darell"," Francis",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B7:D7)","v":"William Darell  Francis"},null,null,"William","Darell"," Francis"]
[null,"Maria ","Snider","Fox","Maria  Snider Fox",null,null,"Maria ","Snider","Fox"]
[null,"Paul"," Green","Harper","Paul  Green Harper",null,null,"Paul"," Green","Harper"]
[null,"Zelda","Mandy"," Cole","Zelda Mandy  Cole",null,null,"Zelda","Mandy"," Cole"]

{"sheet":"Concatenate with delimiter","index":8,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"List of Names",null,null,null,"Try Yourself"]
[]
[null,"Full Name","Full Name (with Delimiter)",null,null,"Full Name","Full Name (with Delimiter)"]
[null,"John Klerk Marshman",{"$f":"CONCATENATE(\"(\",B6,\")\")","v":"(John Klerk Marshman)"},null,null,"John Klerk Marshman"]
[null,"William Darell  Francis",{"$f":"CONCATENATE(\"(\",B7,\")\")","v":"(William Darell  Francis)"},null,null,"William Darell  Francis"]
[null,"Maria  Snider Fox","(Maria  Snider Fox)",null,null,"Maria  Snider Fox"]
[null,"Paul  Green Harper","(Paul  Green Harper)",null,null,"Paul  Green Harper"]
[null,"Zelda Mandy  Cole","(Zelda Mandy  Cole)",null,null,"Zelda Mandy  Cole"]