{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ampersand Operator","CONCAT Function","CHAR Function","TEXTJOIN Function","VBA 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":"Ampersand Operator","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Ampersand Operator"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Adam ","Smith",{"$f":"B5&\" \" & C5","v":"Adam  Smith"}]
[null,"Harry ","Kane",{"$f":"B6&\" \" & C6","v":"Harry  Kane"}]
[null,"Ben","Stokes","Ben Stokes"]
[null,"Cristiano","Ronaldo","Cristiano Ronaldo"]
[null,"Marcus ","Rashford","Marcus  Rashford"]
[null,"Andy","Murray","Andy Murray"]

{"sheet":"CONCAT Function","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CONCAT Function"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"Adam  Smith"}]
[null,"Harry ","Kane",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Harry  Kane"}]
[null,"Ben","Stokes","Ben Stokes"]
[null,"Cristiano","Ronaldo","Cristiano Ronaldo"]
[null,"Marcus ","Rashford","Marcus  Rashford"]
[null,"Andy","Murray","Andy Murray"]

{"sheet":"CHAR Function","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying CHAR Function "]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Adam ","Smith",{"$f":"B5&CHAR(32)&C5","v":"Adam  Smith"}]
[null,"Harry ","Kane",{"$f":"B6&CHAR(32)&C6","v":"Harry  Kane"}]
[null,"Ben","Stokes","Ben Stokes"]
[null,"Cristiano","Ronaldo","Cristiano Ronaldo"]
[null,"Marcus ","Rashford","Marcus  Rashford"]
[null,"Andy","Murray","Andy Murray"]

{"sheet":"TEXTJOIN Function","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Adam ","Smith",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, B5:C5)","v":"Adam  Smith"}]
[null,"Harry ","Kane",{"$f":"_xlfn.TEXTJOIN(\" \", TRUE, B6:C6)","v":"Harry  Kane"}]
[null,"Ben","Stokes","Ben Stokes"]
[null,"Cristiano","Ronaldo","Cristiano Ronaldo"]
[null,"Marcus ","Rashford","Marcus  Rashford"]
[null,"Andy","Murray","Andy Murray"]

{"sheet":"VBA Code","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Applying VBA Code"]
[]
[null,"First Name"," Last Name","Full Name"]
[null,"Adam ","Smith","Adam  Smith"]
[null,"Harry ","Kane","Harry  Kane"]
[null,"Ben","Stokes","Ben Stokes"]
[null,"Cristiano","Ronaldo","Cristiano Ronaldo"]
[null,"Marcus ","Rashford","Marcus  Rashford"]
[null,"Andy","Murray","Andy Murray"]