{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","CONCATENATE","TRANSPOSE","Ampersand","CHAR","TODAY","VBA","TEXTJOIN"],"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employee Record of Armani Group"]
[]
[null,"First Name","Middle Name","Last Name","Concatenate Name"]
[null,"Shaun","Aijack","Lee",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B5:D5)","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,B6:D6)","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton","Kate Despina Middleton"]
[null,"Roger","Marlo","Samuelson","Roger Marlo Samuelson"]
[null,"Mike","Haddin","Johnson","Mike Haddin Johnson"]
[null,"Samuel","Johnson","Taylor","Samuel Johnson Taylor"]
[null,"Mark","Samuelson","Taylor","Mark Samuelson Taylor"]
[null,"Isha","Debolina","Roy","Isha Debolina Roy"]
[null,"Ricky","Santiago","King","Ricky Santiago King"]
[null,"Matthew","Hales","Bairstow","Matthew Hales Bairstow"]

{"sheet":"CONCATENATE","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"CONCATENATE Function to Concatenate Multiple Cells "]
[]
[null,"First Name","Middle Name","Last Name","Concatenate Name"]
[null,"Shaun","Aijack","Lee",{"$f":"CONCATENATE(B5,\" \",C5,\" \",D5)","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"CONCATENATE(B6,\" \",C6,\" \",D6)","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton","Kate Despina Middleton"]
[null,"Roger","Marlo","Samuelson","Roger Marlo Samuelson"]
[null,"Mike","Haddin","Johnson","Mike Haddin Johnson"]
[null,"Samuel","Johnson","Taylor","Samuel Johnson Taylor"]
[null,"Mark","Samuelson","Taylor","Mark Samuelson Taylor"]
[null,"Isha","Debolina","Roy","Isha Debolina Roy"]
[null,"Ricky","Santiago","King","Ricky Santiago King"]
[null,"Matthew","Hales","Bairstow","Matthew Hales Bairstow"]

{"sheet":"TRANSPOSE","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"TRANSPOSE and CONCATENEATE FUNCTIONS"]
[]
[null,"First Name","Samuel",null,{"$f":"CONCATENATE(\"Samuel \",\"Johnson \",\"Taylor \")","v":"Samuel Johnson Taylor "}]
[null,"Middle Name","Johnson"]
[null,"Last Name","Taylor"]

{"sheet":"Ampersand","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employee Record of Armani Group"]
[]
[null,"First Name","Middle Name","Last Name","Combined Name"]
[null,"Shaun","Aijack","Lee",{"$f":"B5&\" \"&C5&\" \"&D5","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"B6&\" \"&C6&\" \"&D6","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton","Kate Despina Middleton"]
[null,"Roger","Marlo","Samuelson","Roger Marlo Samuelson"]
[null,"Mike","Haddin","Johnson","Mike Haddin Johnson"]
[null,"Samuel","Johnson","Taylor","Samuel Johnson Taylor"]
[null,"Mark","Samuelson","Taylor","Mark Samuelson Taylor"]
[null,"Isha","Debolina","Roy","Isha Debolina Roy"]
[null,"Ricky","Santiago","King","Ricky Santiago King"]
[null,"Matthew","Hales","Bairstow","Matthew Hales Bairstow"]

{"sheet":"CHAR","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"CHAR Function to Concatenate Multiple Cells With Space "]
[]
[null,"First Name","Middle Name","Last Name","Combined Name"]
[null,"Shaun","Aijack","Lee",{"$f":"B5&CHAR(32)&C5&CHAR(32)&D5","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"B6&CHAR(32)&C6&CHAR(32)&D6","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton","Kate Despina Middleton"]
[null,"Roger","Marlo","Samuelson","Roger Marlo Samuelson"]
[null,"Mike","Haddin","Johnson","Mike Haddin Johnson"]
[null,"Samuel","Johnson","Taylor","Samuel Johnson Taylor"]
[null,"Mark","Samuelson","Taylor","Mark Samuelson Taylor"]
[null,"Isha","Debolina","Roy","Isha Debolina Roy"]
[null,"Ricky","Santiago","King","Ricky Santiago King"]
[null,"Matthew","Hales","Bairstow","Matthew Hales Bairstow"]

{"sheet":"TODAY","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply the TEXT and TODAY Function "]
[]
[null,"Date","Date Format","Result"]
[null,{"$f":"TODAY()","v":"2022-02-28"},{"$f":" \"Today is \"&TODAY()","v":"Today is 44620"},{"$f":"\"Today is \" &TEXT(TODAY(),\"mm-dd-yy\")","v":"Today is 02-28-22"}]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Run a VBA Code to Concatenate Multiple Cells"]
[]
[null,"First Name","Middle Name","Last Name","Combined Name"]
[null,"Shaun","Aijack","Lee",{"$f":"ConcatenateR(B5:D5)","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"ConcatenateR(B6:D6)","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton",{"$f":"ConcatenateR(B7:D7)","v":"Kate Despina Middleton"}]
[null,"Roger","Marlo","Samuelson",{"$f":"ConcatenateR(B8:D8)","v":"Roger Marlo Samuelson"}]
[null,"Mike","Haddin","Johnson",{"$f":"ConcatenateR(B9:D9)","v":"Mike Haddin Johnson"}]
[null,"Samuel","Johnson","Taylor",{"$f":"ConcatenateR(B10:D10)","v":"Samuel Johnson Taylor"}]
[null,"Mark","Samuelson","Taylor",{"$f":"ConcatenateR(B11:D11)","v":"Mark Samuelson Taylor"}]
[null,"Isha","Debolina","Roy",{"$f":"ConcatenateR(B12:D12)","v":"Isha Debolina Roy"}]
[null,"Ricky","Santiago","King",{"$f":"ConcatenateR(B13:D13)","v":"Ricky Santiago King"}]
[null,"Matthew","Hales","Bairstow",{"$f":"ConcatenateR(B14:D14)","v":"Matthew Hales Bairstow"}]

{"sheet":"TEXTJOIN","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"TEXTJOIN Function to Concatenate Multiple Cells With Space "]
[]
[null,"First Name","Middle Name","Last Name","Combined Name"]
[null,"Shaun","Aijack","Lee",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, B5:D5)","v":"Shaun Aijack Lee"}]
[null,"George","Henry","Orwell",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, B6:D6)","v":"George Henry Orwell"}]
[null,"Kate","Despina","Middleton","Kate Despina Middleton"]
[null,"Roger","Marlo","Samuelson","Roger Marlo Samuelson"]
[null,"Mike","Haddin","Johnson","Mike Haddin Johnson"]
[null,"Samuel","Johnson","Taylor","Samuel Johnson Taylor"]
[null,"Mark","Samuelson","Taylor","Mark Samuelson Taylor"]
[null,"Isha","Debolina","Roy","Isha Debolina Roy"]
[null,"Ricky","Santiago","King","Ricky Santiago King"]
[null,"Matthew","Hales","Bairstow","Matthew Hales Bairstow"]