{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Keyboard","CHAR","Find and Replace","Remove Using F&R","Functions to Remove","VBA","CR in formula"],"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":"Keyboard","index":0,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Keyboard Shortcut",null,null,null,null,null,"Try Yourself"]
[]
[null,"Bob Collins, \nTheoretical Physics, \nPurdue University",null,null,null,null,null,"Bob Collins, Theoretical Physics, Purdue University"]

{"sheet":"CHAR","index":1,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,11]]}
[]
[null,"Using CHAR, CONCATENATE & TEXTJOIN Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Department","University","Full Text",null,null,null,"Name","Department","University","Full Text"]
[null,"Mike","Applied Physics","Purdue University ",{"$f":"B5&\" \"&CHAR(10)&C5&\" \"&CHAR(10)&D5","v":"Mike \nApplied Physics \nPurdue University "},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=B5&\" \"&CHAR(10)&C5&\" \"&CHAR(10)&D5"},null,null,"Mike","Applied Physics","Purdue University "]
[null,"Adam","Mechanical Engineering","MIT",{"$f":"CONCATENATE(B6,CHAR(10),C6,CHAR(10),D6)","v":"Adam\nMechanical Engineering\nMIT"},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=CONCATENATE(B6,CHAR(10),C6,CHAR(10),D6)"},null,null,"Adam","Mechanical Engineering","MIT"]
[null,"David","Applied Chemistry","University of Cambridge",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,B7:D7)","v":"David\nApplied Chemistry\nUniversity of Cambridge"},"=TEXTJOIN(CHAR(10),TRUE,B7:D7)",null,null,"David","Applied Chemistry","University of Cambridge"]

{"sheet":"Find and Replace","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"With Find and Replace Dialogue Box",null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,"Data"]
[null,"Mike\nApplied Physics\nPurdue University",null,null,null,null,"Mike, Applied Physics, Purdue University"]
[null,"Adam\nMechanical Engineering\nMIT",null,null,null,null,"Adam, Mechanical Engineering, MIT"]
[null,"David\nApplied Chemistry\nUniversity of Cambridge",null,null,null,null,"David, Applied Chemistry, University of Cambridge"]

{"sheet":"Remove Using F&R","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Find & Replace to Remove",null,null,null,null,"Try Yourself"]
[]
[null,"Data",null,null,null,null,"Data"]
[null,"Mike, Applied Physics, Purdue University",null,null,null,null,"Mike\nApplied Physics\nPurdue University"]
[null,"Adam, Mechanical Engineering, MIT",null,null,null,null,"Adam\nMechanical Engineering\nMIT"]
[null,"David, Applied Chemistry, University of Cambridge",null,null,null,null,"David\nApplied Chemistry\nUniversity of Cambridge"]

{"sheet":"Functions to Remove","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,8]]}
[]
[null,"Remove Using TRIM and SUBSTITUTE Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"With Carriage Return","Without Carriage Return",null,null,null,null,"With Carriage Return","Without Carriage Return"]
[null,"Mike\nApplied Physics\nPurdue University",{"$f":"TRIM(SUBSTITUTE(SUBSTITUTE(B5,CHAR(13),\"\"),CHAR(10),\", \"))","v":"Mike, Applied Physics, Purdue University"},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=TRIM(SUBSTITUTE(SUBSTITUTE(B5,CHAR(13),\"\"),CHAR(10),\", \"))"},null,null,null,"Mike\nApplied Physics\nPurdue University"]
[null,"Adam\nMechanical Engineering\nMIT",{"$f":"SUBSTITUTE(B6,CHAR(10),\", \")","v":"Adam, Mechanical Engineering, MIT"},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=SUBSTITUTE(B6,CHAR(10),\", \")"},null,null,null,"Adam\nMechanical Engineering\nMIT"]

{"sheet":"VBA","index":5,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Information",null,null,null,null,null,null,null,"Information"]
[null,"Mike\nApplied Physics\nPurdue University",null,null,null,null,null,null,null,"Mike\nApplied Physics\nPurdue University"]
[null,"Adam\nMechanical Engineering\nMIT",null,null,null,null,null,null,null,"Adam\nMechanical Engineering\nMIT"]

{"sheet":"CR in formula","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Age","Eligibility"]
[null,15,{"$f":"IF(B3<30,\nIF(B3<20,\"Below 20\",\"20s\"),\n\"Over 30\")","v":"Below 20"}]
[null,19,{"$f":"IF(B4<30,IF(B4<20,\"Below 20\",\"20s\"),\"Over 30\")","v":"Below 20"}]
[null,22,"20s"]
[null,23,"20s"]
[null,35,"Over 30"]