{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Basic Dataset","TRIM Function","TRIM not Working","VBA","Find Trailing Space"],"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":"Basic Dataset","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Best Movie List"]
[]
[null,"Movie","Year"]
[null,"  Pulp  Fiction   ",1994]
[null," 12 Angry Men ",1957]
[null,"The Matrix   ",1999]
[null," Goodfellas  ",1990]
[null,"Seven Samurai ",1954]
[null," City of God   ",2002]
[null,"Interstellar    ",2014]
[null," Spirited Away ",2011]

{"sheet":"TRIM Function","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Usage of TRIM Function",null,null,null,null,null,"Practice Here"]
[]
[null,"Movie Name","Year","Normalized Movie Name",null,null,null,"Movie Name","Year","Normalized Movie Name"]
[null,"  Pulp  Fiction   ",1994,{"$f":"TRIM(B5)","v":"Pulp Fiction  "},null,null,null,"  Pulp  Fiction   ",1994]
[null," 12 Angry Men ",1957,{"$f":"TRIM(B6)","v":"12 Angry Men"},null,null,null," 12 Angry Men ",1957]
[null,"The Matrix   ",1999,"The Matrix",null,null,null,"The Matrix   ",1999]
[null," Goodfellas  ",1990,"Goodfellas",null,null,null," Goodfellas  ",1990]
[null,"Seven Samurai ",1954,"Seven Samurai",null,null,null,"Seven Samurai ",1954]
[null," City of God   ",2002,"City of God",null,null,null," City of God   ",2002]
[null,"Interstellar    ",2014,"Interstellar",null,null,null,"Interstellar    ",2014]
[null," Spirited Away ",2011,"Spirited Away",null,null,null," Spirited Away ",2011]

{"sheet":"TRIM not Working","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"TRIM Function isn't Working",null,null,null,null,null,"Practice Here"]
[]
[null,"Movie Name","Year","Normalized Movie Name",null,null,null,"Movie Name","Year","Normalized Movie Name"]
[null,"  Pulp  Fiction   ",1994,null,null,null,null,"  Pulp  Fiction   ",1994]
[null," 12 Angry Men ",1957,null,null,null,null," 12 Angry Men ",1957]
[null,"The Matrix    ",1999,{"$f":"TRIM(SUBSTITUTE(B7, CHAR(160),\" \"))","v":"The Matrix"},null,null,null,"The Matrix   ",1999]
[null," Goodfellas  ",1990,null,null,null,null," Goodfellas  ",1990]
[null,"Seven Samurai ",1954,null,null,null,null,"Seven Samurai ",1954]
[null," City of God   ",2002,null,null,null,null," City of God   ",2002]
[null,"Interstellar    ",2014,null,null,null,null,"Interstellar    ",2014]
[null," Spirited Away ",2011,null,null,null,null," Spirited Away ",2011]

{"sheet":"VBA","index":3,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Usage of VBA",null,null,null,null,null,"Practice Here"]
[]
[null,"Movie Name","Year","Normalized Movie Name",null,null,null,"Movie Name","Year","Normalized Movie Name"]
[null,"Pulp  Fiction   ",1994,null,null,null,null,"  Pulp  Fiction   ",1994]
[null,"12 Angry Men",1957,null,null,null,null," 12 Angry Men ",1957]
[null,"The Matrix",1999,null,null,null,null,"The Matrix   ",1999]
[null,"Goodfellas",1990,null,null,null,null," Goodfellas  ",1990]
[null,"Seven Samurai",1954,null,null,null,null,"Seven Samurai ",1954]
[null,"City of God",2002,null,null,null,null," City of God   ",2002]
[null,"Interstellar",2014,null,null,null,null,"Interstellar    ",2014]
[null,"Spirited Away",2011,null,null,null,null," Spirited Away ",2011]

{"sheet":"Find Trailing Space","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Find Trailing Space",null,null,null,null,null,"Practice Here"]
[]
[null,"Movie Name","Year","Trailing Space",null,null,null,"Movie Name","Year","Normalized Movie Name"]
[null,"  Pulp  Fiction",1994,{"$f":"IF(RIGHT(B5,1)=\" \",\"Present\",\"Absent\")","v":"Absent"},null,null,null,"  Pulp  Fiction   ",1994]
[null," 12 Angry Men ",1957,{"$f":"IF(RIGHT(B6,1)=\" \",\"Present\",\"Absent\")","v":"Present"},null,null,null," 12 Angry Men ",1957]
[null,"The Matrix   ",1999,"Present",null,null,null,"The Matrix   ",1999]
[null," Goodfellas  ",1990,"Present",null,null,null," Goodfellas  ",1990]
[null,"Seven Samurai",1954,"Absent",null,null,null,"Seven Samurai ",1954]
[null," City of God   ",2002,"Present",null,null,null," City of God   ",2002]
[null,"Interstellar    ",2014,"Present",null,null,null,"Interstellar    ",2014]
[null," Spirited Away ",2011,"Present",null,null,null," Spirited Away ",2011]