{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","CONCATENATE","CONCAT","TEXTJOIN","Ampersand","Cell Format","Flash Fill","Keyboard","VBA"],"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Adding Text to Cell Without Deleting"]
[]
[null,"Name","Result",null,"Text"]
[null,"Harry",null,null,"Mr. "]
[null,"Ron"]
[null,"Tom"]
[null,"Malfoy"]
[null,"Longbottom"]
[null,"Snap"]
[null,"Reddle"]
[null,"Sonny"]
[null,"Michal"]
[null,"Jerry"]

{"sheet":"CONCATENATE","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying CONCATENATE Function"]
[]
[null,"Name","New Text",null,"Text"]
[null,"Harry",{"$f":"CONCATENATE($E$5,B5)","v":"Mr. Harry"},null,"Mr. "]
[null,"Ron",{"$f":"CONCATENATE($E$5,B6)","v":"Mr. Ron"}]
[null,"Tom","Mr. Tom"]
[null,"Malfoy","Mr. Malfoy"]
[null,"Longbottom","Mr. Longbottom"]
[null,"Snap","Mr. Snap"]
[null,"Reddle","Mr. Reddle"]
[null,"Sonny","Mr. Sonny"]
[null,"Michal","Mr. Michal"]
[null,"Jerry","Mr. Jerry"]

{"sheet":"CONCAT","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using CONCAT Function "]
[]
[null,"Name","New Text",null,"Text"]
[null,"Harry",{"$f":"_xlfn.CONCAT($E$5,B5)","v":"Mr. Harry"},null,"Mr. "]
[null,"Ron",{"$f":"_xlfn.CONCAT($E$5,B6)","v":"Mr. Ron"}]
[null,"Tom","Mr. Tom"]
[null,"Malfoy","Mr. Malfoy"]
[null,"Longbottom","Mr. Longbottom"]
[null,"Snap","Mr. Snap"]
[null,"Reddle","Mr. Reddle"]
[null,"Sonny","Mr. Sonny"]
[null,"Michal","Mr. Michal"]
[null,"Jerry","Mr. Jerry"]

{"sheet":"TEXTJOIN","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing TEXTJOIN Function"]
[]
[null,"Name","Result",null,"Text"]
[null,"Harry",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$E$5,B5)","v":"Mr. Harry"},null,"Mr. "]
[null,"Ron",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$E$5,B6)","v":"Mr. Ron"}]
[null,"Tom","Mr. Tom"]
[null,"Malfoy","Mr. Malfoy"]
[null,"Longbottom","Mr. Longbottom"]
[null,"Snap","Mr. Snap"]
[null,"Reddle","Mr. Reddle"]
[null,"Sonny","Mr. Sonny"]
[null,"Michal","Mr. Michal"]
[null,"Jerry","Mr. Jerry"]

{"sheet":"Ampersand","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Ampersand Operator"]
[]
[null,"Name","Result",null,"Text"]
[null,"Harry",{"$f":"$E$5&B5","v":"Mr. Harry"},null,"Mr. "]
[null,"Ron",{"$f":"$E$5&B6","v":"Mr. Ron"}]
[null,"Tom","Mr. Tom"]
[null,"Malfoy","Mr. Malfoy"]
[null,"Longbottom","Mr. Longbottom"]
[null,"Snap","Mr. Snap"]
[null,"Reddle","Mr. Reddle"]
[null,"Sonny","Mr. Sonny"]
[null,"Michal","Mr. Michal"]
[null,"Jerry","Mr. Jerry"]

{"sheet":"Cell Format","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Modifying Cell Format"]
[]
[null,"Name",null,"Text"]
[null,"Harry",null,"Mr. "]
[null,"Ron"]
[null,"Tom"]
[null,"Malfoy"]
[null,"Longbottom"]
[null,"Snap"]
[null,"Reddle"]
[null,"Sonny"]
[null,"Michal"]
[null,"Jerry"]

{"sheet":"Flash Fill","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Flash Fill Command"]
[]
[null,"Name","New Text",null,"Text"]
[null,"Harry","Mr. Harry",null,"Mr. "]
[null,"Ron","Mr. Ron"]
[null,"Tom","Mr. Tom"]
[null,"Malfoy","Mr. Malfoy"]
[null,"Longbottom","Mr. Longbottom"]
[null,"Snap","Mr. Snap"]
[null,"Reddle","Mr. Reddle"]
[null,"Sonny","Mr. Sonny"]
[null,"Michal","Mr. Michal"]
[null,"Jerry","Mr. Jerry"]

{"sheet":"Keyboard","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Keyboard Shortcut"]
[]
[null,"Name",null,"Text"]
[null,"Mr. Harry",null,"Mr. "]
[null,"Mr. Ron"]
[null,"Mr. Tom"]
[null,"Mr. Malfoy"]
[null,"Mr. Longbottom"]
[null,"Mr. Snap"]
[null,"Mr. Reddle"]
[null,"Mr. Sonny"]
[null,"Mr. Michal"]
[null,"Mr. Jerry"]

{"sheet":"VBA","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Name",null,"Text"]
[null,"Mr. Harry",null,"Mr. "]
[null,"Mr. Ron"]
[null,"Mr. Tom"]
[null,"Mr. Malfoy"]
[null,"Mr. Longbottom"]
[null,"Mr. Snap"]
[null,"Mr. Reddle"]
[null,"Mr. Sonny"]
[null,"Mr. Michal"]
[null,"Mr. Jerry"]