{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["CHAR","TEXTJOIN","Find & Replace","VBA","Cell Value","Formula","Named Formula","Remove"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"CHAR","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using CHAR Function"]
[]
[null,"ID","Name","Department",null,"Line Break"]
[null,101,"Mike","Philosphy",null,{"$f":"B5&CHAR(10)&C5&CHAR(10)&D5","v":"101\nMike\nPhilosphy"}]
[null,102,"Adam","Literature",null,{"$f":"B6&CHAR(10)&C6&CHAR(10)&D6","v":"102\nAdam\nLiterature"}]
[null,103,"David","Geology",null,"103\nDavid\nGeology"]
[null,104,"Cristopher","Mathematics",null,"104\nCristopher\nMathematics"]
[null,105,"Stuart","Chemistry",null,"105\nStuart\nChemistry"]
[null,106,"Robin","Applied Physics",null,"106\nRobin\nApplied Physics"]
[null,107,"Milford","Civil Engineering",null,"107\nMilford\nCivil Engineering"]
[null,108,"John","Mechanical Engineering",null,"108\nJohn\nMechanical Engineering"]
[null,109,"Bob","History",null,"109\nBob\nHistory"]
[null,110,"Collins","Economics",null,"110\nCollins\nEconomics"]

{"sheet":"TEXTJOIN","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using TEXTJOIN Function"]
[]
[null,"ID","Name","Department",null,"Line Break"]
[null,101,"Mike","Philosphy",null,{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,B5:D5)","v":"101\nMike\nPhilosphy"}]
[null,102,"Adam","Literature",null,"102\nAdam\nLiterature"]
[null,103,"David","Geology",null,"103\nDavid\nGeology"]
[null,104,"Cristopher","Mathematics",null,"104\nCristopher\nMathematics"]
[null,105,"Stuart","Chemistry",null,"105\nStuart\nChemistry"]
[null,106,"Robin","Applied Physics",null,"106\nRobin\nApplied Physics"]
[null,107,"Milford","Civil Engineering",null,"107\nMilford\nCivil Engineering"]
[null,108,"John","Mechanical Engineering",null,"108\nJohn\nMechanical Engineering"]
[null,109,"Bob","History",null,"109\nBob\nHistory"]
[null,110,"Collins","Economics",null,"110\nCollins\nEconomics"]

{"sheet":"Find & Replace","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Find and Replace Feature"]
[]
[null,"ID","Name","Department",null,"Line Break"]
[null,101,"Mike","Philosphy",null,{"$f":"B5&CHAR(10)&C5&CHAR(10)&D5","v":"101\nMike\nPhilosphy"}]
[null,102,"Adam","Literature",null,"102\nAdam\nLiterature"]
[null,103,"David","Geology",null,"103\nDavid\nGeology"]
[null,104,"Cristopher","Mathematics",null,"104\nCristopher\nMathematics"]
[null,105,"Stuart","Chemistry",null,"105\nStuart\nChemistry"]
[null,106,"Robin","Applied Physics",null,"106\nRobin\nApplied Physics"]
[null,107,"Milford","Sociology",null,"107\nMilford\nSociology"]
[null,108,"John","Statistics",null,"108\nJohn\nStatistics"]
[null,109,"Bob","History",null,"109\nBob\nHistory"]
[null,110,"Collins","Economics",null,"110\nCollins\nEconomics"]

{"sheet":"VBA","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Code"]
[]
[null,"ID","Name","Department",null,"Line\r\nBreak"]
[null,101,"Mike","Philosphy",null,"101\r\nMike\r\nPhilosphy"]
[null,102,"Adam","Literature",null,"102\r\nAdam\r\nLiterature"]
[null,103,"David","Geology",null,"103\r\nDavid\r\nGeology"]
[null,104,"Cristopher","Mathematics",null,"104\r\nCristopher\r\nMathematics"]
[null,105,"Stuart","Chemistry",null,"105\r\nStuart\r\nChemistry"]
[null,106,"Robin","Applied Physics",null,"106\r\nRobin\r\nApplied Physics"]
[null,107,"Milford","Civil Engineering",null,"107\r\nMilford\r\nCivil Engineering"]
[null,108,"John","Mechanical Engineering",null,"108\r\nJohn\r\nMechanical Engineering"]
[null,109,"Bob","History",null,"109\r\nBob\r\nHistory"]
[null,110,"Collins","Economics",null,"110\r\nCollins\r\nEconomics"]

{"sheet":"Cell Value","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"New Line in Cell Value"]
[]
[null,"ID","Name","Department",null,"Line Break"]
[null,101,"Mike","Philosphy",null,"101,\nMike,\nPhilosphy"]
[null,102,"Adam","Literature",null,"102,\nAdam,\nLiterature"]
[null,103,"David","Geology",null,"103,\nDavid,\nGeology"]
[null,104,"Cristopher","Mathematics",null,"104,\nCristopher,\nMathematics"]
[null,105,"Stuart","Chemistry",null,"105,\nStuart,\nChemistry"]
[null,106,"Robin","Applied Physics",null,"106,\nRobin,\nApplied Physics"]
[null,107,"Milford","Civil Engineering",null,"107,\nMilford,\nCivil Engineering"]
[null,108,"John","Mechanical Engineering",null,"108,\nJohn,\nMechanical Engineering"]
[null,109,"Bob","History",null,"109,\nBob,\nHistory"]
[null,110,"Collins","Economics",null,"110,\nCollins,\nEconomics"]

{"sheet":"Formula","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"New Line in Formula"]
[]
[null,"ID","Name","Department","Marks Obtained","Status"]
[null,101,"Mike","Philosphy",86,{"$f":"IF(E5>=80,\"Great\",IF(E5>=70,\"Good\",IF(E5>=60,\"Satisfactory\",IF(E5<60,\"Bad\"))))","v":"Great"}]
[null,102,"Adam","Literature",53,{"$f":"IF(E6>=80,\"Great\",IF(E6>=70,\"Good\",IF(E6>=60,\"Satisfactory\",IF(E6<60,\"Bad\"))))","v":"Bad"}]
[null,103,"David","Geology",65,"Satisfactory"]
[null,104,"Cristopher","Mathematics",76,"Good"]
[null,105,"Stuart","Chemistry",90,"Great"]
[null,106,"Robin","Physics",78,"Good"]
[null,107,"Milford","Sociology",56,"Bad"]
[null,108,"John","Statistics",88,"Great"]
[null,109,"Bob","History",63,"Satisfactory"]
[null,110,"Collins","Economics",76,"Good"]

{"sheet":"Named Formula","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Defining Name to Formula"]
[]
[null,"ID","Name","Department",null,"Line Break"]
[null,101,"Mike","Philosphy",null,{"$f":"B5&NewLine&C5&NewLine&D5","v":"101\nMike\nPhilosphy"}]
[null,102,"Adam","Literature",null,{"$f":"B6&NewLine&C6&NewLine&D6","v":"102\nAdam\nLiterature"}]
[null,103,"David","Geology",null,{"$f":"B7&NewLine&C7&NewLine&D7","v":"103\nDavid\nGeology"}]
[null,104,"Cristopher","Mathematics",null,{"$f":"B8&NewLine&C8&NewLine&D8","v":"104\nCristopher\nMathematics"}]
[null,105,"Stuart","Chemistry",null,{"$f":"B9&NewLine&C9&NewLine&D9","v":"105\nStuart\nChemistry"}]
[null,106,"Robin","Applied Physics",null,{"$f":"B10&NewLine&C10&NewLine&D10","v":"106\nRobin\nApplied Physics"}]
[null,107,"Milford","Sociology",null,{"$f":"B11&NewLine&C11&NewLine&D11","v":"107\nMilford\nSociology"}]
[null,108,"John","Statistics",null,{"$f":"B12&NewLine&C12&NewLine&D12","v":"108\nJohn\nStatistics"}]
[null,109,"Bob","History",null,{"$f":"B13&NewLine&C13&NewLine&D13","v":"109\nBob\nHistory"}]
[null,110,"Collins","Economics",null,{"$f":"B14&NewLine&C14&NewLine&D14","v":"110\nCollins\nEconomics"}]

{"sheet":"Remove","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Removing New Line in Cell Formula"]
[]
[null,"Line Break",null,"Line Break Removed"]
[null,"101,\nMike,\nPhilosphy",null,{"$f":"SUBSTITUTE(B5,CHAR(10),\"\")","v":"101,Mike,Philosphy"}]
[null,"102,\nAdam,\nLiterature",null,{"$f":"SUBSTITUTE(B6,CHAR(10),\"\")","v":"102,Adam,Literature"}]
[null,"103,\nDavid,\nGeology",null,"103,David,Geology"]
[null,"104,\nCristopher,\nMathematics",null,"104,Cristopher,Mathematics"]
[null,"105,\nStuart,\nChemistry",null,"105,Stuart,Chemistry"]
[null,"106,\nRobin,\nApplied Physics",null,"106,Robin,Applied Physics"]
[null,"107,\nMilford,\nCivil Engineering",null,"107,Milford,Civil Engineering"]
[null,"108,\nJohn,\nMechanical Engineering",null,"108,John,Mechanical Engineering"]
[null,"109,\nBob,\nHistory",null,"109,Bob,History"]
[null,"110,\nCollins,\nEconomics",null,"110,Collins,Economics"]