{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Ampersand","CONCATENATE","Flash Fill","Add Word in the Begining","Add Word in the End","February","March"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using Ampersand",null,null,"Try Yourself"]
[]
[null,"Name","Output",null,"Name","Output"]
[null,"Luka",{"$f":"\"Mr. \"&B5","v":"Mr. Luka"},null,"Luka"]
[null,"Oliver",{"$f":"\"Mr. \"&B6","v":"Mr. Oliver"},null,"Oliver"]
[null,"Robin","Mr. Robin",null,"Robin"]
[null,"Aron","Mr. Aron",null,"Aron"]
[null,"Leo","Mr. Leo",null,"Leo"]
[null,"Henry","Mr. Henry",null,"Henry"]

{"sheet":"CONCATENATE","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Applying CONCATENATE Function",null,null,"Try Yourself"]
[]
[null,"Name","Output",null,"Name","Output"]
[null,"Luka",{"$f":"CONCATENATE(\"Mr. \",B5)","v":"Mr. Luka"},null,"Luka"]
[null,"Oliver",{"$f":"CONCATENATE(\"Mr. \",B6)","v":"Mr. Oliver"},null,"Oliver"]
[null,"Robin","Mr. Robin",null,"Robin"]
[null,"Aron","Mr. Aron",null,"Aron"]
[null,"Leo","Mr. Leo",null,"Leo"]
[null,"Henry","Mr. Henry",null,"Henry"]

{"sheet":"Flash Fill","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using Excel Flash Fill",null,null,"Try Yourself"]
[]
[null,"Name","Output",null,"Name","Output"]
[null,"Luka","Mr. Luka",null,"Luka"]
[null,"Oliver","Mr. Oliver",null,"Oliver"]
[null,"Robin","Mr. Robin",null,"Robin"]
[null,"Aron","Mr. Aron",null,"Aron"]
[null,"Leo","Mr. Leo",null,"Leo"]
[null,"Henry","Mr. Henry",null,"Henry"]

{"sheet":"Add Word in the Begining","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using VBA: Add Word in the Beginning",null,null,"Try Yourself"]
[]
[null,"Name","Output",null,"Name","Output"]
[null,"Luka","Mr. Luka",null,"Luka"]
[null,"Oliver","Mr. Oliver",null,"Oliver"]
[null,"Robin","Mr. Robin",null,"Robin"]
[null,"Aron","Mr. Aron",null,"Aron"]
[null,"Leo","Mr. Leo",null,"Leo"]
[null,"Henry","Mr. Henry",null,"Henry"]

{"sheet":"Add Word in the End","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Using VBA: Add Word in the Beginning",null,null,"Try Yourself"]
[]
[null,"Name","Output",null,"Name","Output"]
[null,"Luka","Luka-SP",null,"Luka"]
[null,"Oliver","Oliver-SP",null,"Oliver"]
[null,"Robin","Robin-SP",null,"Robin"]
[null,"Aron","Aron-SP",null,"Aron"]
[null,"Leo","Leo-SP",null,"Leo"]
[null,"Henry","Henry-SP",null,"Henry"]

{"sheet":"February","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Applying Inspect Document Function"]
[]
[null,"Salesperson","Region","Sales"]
[null,"Luka","Canada",67463]
[null,"Oliver","UK",78453]
[null,"Robin","London",48763]
[null,"Aron","UK",38725]
[null,"Leo","USA",78435]
[null,"Henry","USA",67329]
[null,"James","London",27854]

{"sheet":"March","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Applying Inspect Document Function"]
[]
[null,"Salesperson","Region","Sales"]
[null,"Luka","Canada",82564]
[null,"Oliver","UK",19845]
[null,"Robin","London",67342]
[null,"Aron","UK",67453]
[null,"Leo","USA",89163]
[null,"Henry","USA",78236]
[null,"James","London",78345]