{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1.CONCAT Function","2.Justify Feature","3. TEXTJOIN Function","4. Ampersand","5. Merge & Center","6.1 Macro","6.2 Macro (2)"],"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":"1.CONCAT Function","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of CONCAT Function",null,null,null,null,null,"Try yourself"]
[]
[null,"221B",{"$f":"_xlfn.CONCAT(B4,\" \",B5,\" \",B6)","v":"221B Baker Street"},null,null,null,null,"221B"]
[null,"Baker",null,null,null,null,null,"Baker"]
[null,"Street",null,null,null,null,null,"Street"]

{"sheet":"2.Justify Feature","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null," Use of Justify Feature",null,null,null,"Try Yourself"]
[]
[null,"Pussy Cat Pussy Cat Where Have You Been",null,null,null,"Bla"]
[null,null,null,null,null,"Bla"]
[null,null,null,null,null,"Black sheep"]
[null,null,null,null,null,"Have you any wool?"]

{"sheet":"3. TEXTJOIN Function","index":2,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,8,1,11],[1,1,1,4]]}
[]
[null,"Use of TEXTJOIN Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"PRODUCTS",null,"Customer","Products",null,null,null,"PRODUCTS",null,"Customer","Products"]
[null,"Orange",null,"Rob",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B5:B8)","v":"Orange, Banana, Apple, Lemons"},null,null,null,"Orange",null,"Rob"]
[null,"Banana",null,null,null,null,null,null,"Banana"]
[null,"Apple",null,null,null,null,null,null,"Apple"]
[null,"Lemons",null,null,null,null,null,null,"Lemons"]

{"sheet":"4. Ampersand","index":3,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of Ampersand Operator",null,null,null,null,null,null,"Use of Ampersand Operator"]
[]
[null,"PRODUCTS",null,"Customer","Products",null,null,null,"PRODUCTS",null,"Customer","Products"]
[null,"Orange",null,"Rob",{"$f":"B5&\", \"&B6&\", \"&B7&\", \"&B8","v":"Orange, Banana, Apple, Lemons"},null,null,null,"Orange",null,"Rob"]
[null,"Banana",null,null,null,null,null,null,"Banana"]
[null,"Apple",null,null,null,null,null,null,"Apple"]
[null,"Lemons",null,null,null,null,null,null,"Lemons"]

{"sheet":"5. Merge & Center","index":4,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[4,2,7,2]]}
[]
[null,"Book Record of Kingfisher Bookstore",null,null,"Try Yourself"]
[]
[null,"Author","Name of the Book",null,"Author","Name of the Book"]
[null,"Charles Dickens","A Tale of Two Cities",null,"Charles Dickens","A Tale of Two Cities"]
[null,null,null,null,null,"Great Expectations"]
[null,null,null,null,null,"Oliver Twist"]
[null,null,null,null,null,"David Copperfield"]
[null,"P. B. Shelly","Ode to the West Wind",null,"P. B. Shelly","Ode to the West Wind"]
[null,null,"To a Skylark",null,null,"To a Skylark"]
[null,null,"Queen Mab",null,null,"Queen Mab"]
[null,"Sir H.Rider Haggard","She",null,"Sir H.Rider Haggard","She"]
[null,null,"And Return of She",null,null,"And Return of She"]
[null,null,"The Virgin of the Sun",null,null,"The Virgin of the Sun"]
[null,null,"The People of the Mist",null,null,"The People of the Mist"]
[null,null,"The Bretheren",null,null,"The Bretheren"]
[null,null,"Montejuma's Daughter",null,null,"Montejuma's Daughter"]
[null,null,"Pearl Maiden",null,null,"Pearl Maiden"]
[null,"Eliff Shafak","The Forty Rules of Love",null,"Eliff Shafak","The Forty Rules of Love"]
[null,null,"The Bastard of Istambul",null,null,"The Bastard of Istambul"]
[null,"George Orwell","1984",null,"George Orwell","1984"]
[null,null,"Animal Firm",null,null,"Animal Firm"]
[null,"Earnest Hemingway","The Old Man and the Sea",null,"Earnest Hemingway","The Old Man and the Sea"]
[null,null,"A Farewell to Arms",null,null,"A Farewell to Arms"]
[null,null,"The Sun Also Rises",null,null,"The Sun Also Rises"]
[null,"Erik Maria Remark","All Quiet in the Western Front",null,"Erik Maria Remark","All Quiet in the Western Front"]
[null,null,"Three Comrades",null,null,"Three Comrades"]
[null,null,"Night in Lisbon",null,null,"Night in Lisbon"]

{"sheet":"6.1 Macro","index":5,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,1,27,1],[25,2,27,2],[18,1,19,1],[18,2,19,2],[20,1,21,1],[20,2,21,2],[22,1,24,1],[22,2,24,2],[4,1,7,1],[4,2,7,2],[8,1,10,1],[8,2,10,2],[11,1,17,1],[11,2,17,2],[1,1,1,2],[1,5,1,6]]}
[]
[null,"Book Record of Kingfisher Bookstore",null,null,null,"Try Yourself"]
[]
[null,"Author","Name of the Book",null,null,"Author","Name of the Book"]
[null,"Charles Dickens","A Tale of Two Cities\r\nGreat Expectations\r\nOliver Twist\r\nDavid Copperfield",null,null,"Charles Dickens","A Tale of Two Cities"]
[null,null,null,null,null,null,"Great Expectations"]
[null,null,null,null,null,null,"Oliver Twist"]
[null,null,null,null,null,null,"David Copperfield"]
[null,"P. B. Shelly","Ode to the West Wind\r\nTo a Skylark\r\nQueen Mab",null,null,"P. B. Shelly","Ode to the West Wind"]
[null,null,null,null,null,null,"To a Skylark"]
[null,null,null,null,null,null,"Queen Mab"]
[null,"Sir H.Rider Haggard","She\r\nAnd Return of She\r\nThe Virgin of the Sun\r\nThe People of the Mist\r\nThe Bretheren\r\nMontejuma's Daughter\r\nPearl Maiden",null,null,"Sir H.Rider Haggard","She"]
[null,null,null,null,null,null,"And Return of She"]
[null,null,null,null,null,null,"The Virgin of the Sun"]
[null,null,null,null,null,null,"The People of the Mist"]
[null,null,null,null,null,null,"The Bretheren"]
[null,null,null,null,null,null,"Montejuma's Daughter"]
[null,null,null,null,null,null,"Pearl Maiden"]
[null,"Eliff Shafak","The Forty Rules of Love\r\nThe Bastard of Istambul",null,null,"Eliff Shafak","The Forty Rules of Love"]
[null,null,null,null,null,null,"The Bastard of Istambul"]
[null,"George Orwell","1984\r\nAnimal Firm",null,null,"George Orwell","1984"]
[null,null,null,null,null,null,"Animal Firm"]
[null,"Earnest Hemingway","The Old Man and the Sea\r\nA Farewell to Arms\r\nThe Sun Also Rises",null,null,"Earnest Hemingway","The Old Man and the Sea"]
[null,null,null,null,null,null,"A Farewell to Arms"]
[null,null,null,null,null,null,"The Sun Also Rises"]
[null,"Erik Maria Remark","All Quiet in the Western Front\r\nThree Comrades\r\nNight in Lisbon",null,null,"Erik Maria Remark","All Quiet in the Western Front"]
[null,null,null,null,null,null,"Three Comrades"]
[null,null,null,null,null,null,"Night in Lisbon"]

{"sheet":"6.2 Macro (2)","index":6,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[21,1,27,1],[21,2,27,2],[13,1,15,1],[13,2,15,2],[16,1,17,1],[16,2,17,2],[18,1,20,1],[18,2,20,2],[4,1,7,1],[4,2,7,2],[8,1,10,1],[8,2,10,2],[11,1,12,1],[11,2,12,2],[1,6,1,7],[1,1,1,2]]}
[]
[null,"Book Record of Kingfisher Bookstore",null,null,null,null,"Try Yourself"]
[]
[null,"Author","Name of the Book",null,null,null,"Author","Name of the Book"]
[null,"Charles Dickens","\r\nA Tale of Two Cities\r\nDavid Copperfield\r\nOliver Twist\r\nGreat Expectations",null,null,null,"Eliff Shafak","The Forty Rules of Love"]
[null,null,null,null,null,null,"Sir H.Rider Haggard","Montejuma's Daughter"]
[null,null,null,null,null,null,"Earnest Hemingway","The Sun Also Rises"]
[null,null,null,null,null,null,"Charles Dickens","A Tale of Two Cities"]
[null,"Earnest Hemingway","\r\nThe Sun Also Rises\r\nThe Old Man and the Sea\r\nA Farewell to Arms",null,null,null,"P. B. Shelly","Queen Mab"]
[null,null,null,null,null,null,"Eliff Shafak","The Bastard of Istambul"]
[null,null,null,null,null,null,"George Orwell","1984"]
[null,"Eliff Shafak","\r\nThe Forty Rules of Love\r\nThe Bastard of Istambul",null,null,null,"Charles Dickens","David Copperfield"]
[null,null,null,null,null,null,"P. B. Shelly","Ode to the West Wind"]
[null,"Erik Maria Remark","\r\nAll Quiet in the Western Front\r\nThree Comrades\r\nNight in Lisbon",null,null,null,"Charles Dickens","Oliver Twist"]
[null,null,null,null,null,null,"P. B. Shelly","To a Skylark"]
[null,null,null,null,null,null,"Charles Dickens","Great Expectations"]
[null,"George Orwell","\r\n1984\r\nAnimal Firm",null,null,null,"Sir H.Rider Haggard","She"]
[null,null,null,null,null,null,"George Orwell","Animal Firm"]
[null,"P. B. Shelly","\r\nQueen Mab\r\nOde to the West Wind\r\nTo a Skylark",null,null,null,"Earnest Hemingway","The Old Man and the Sea"]
[null,null,null,null,null,null,"Sir H.Rider Haggard","And Return of She"]
[null,null,null,null,null,null,"Sir H.Rider Haggard","The Virgin of the Sun"]
[null,"Sir H.Rider Haggard","\r\nMontejuma's Daughter\r\nShe\r\nAnd Return of She\r\nThe Virgin of the Sun\r\nThe People of the Mist\r\nThe Bretheren\r\nPearl Maiden",null,null,null,"Sir H.Rider Haggard","The People of the Mist"]
[null,null,null,null,null,null,"Sir H.Rider Haggard","The Bretheren"]
[null,null,null,null,null,null,"Sir H.Rider Haggard","Pearl Maiden"]
[null,null,null,null,null,null,"Earnest Hemingway","A Farewell to Arms"]
[null,null,null,null,null,null,"Erik Maria Remark","All Quiet in the Western Front"]
[null,null,null,null,null,null,"Erik Maria Remark","Three Comrades"]
[null,null,null,null,null,null,"Erik Maria Remark","Night in Lisbon"]