{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Basic Dataset","TRIM Function","SUBSTITUTE Function","CLEAN with TRIM Function","Find & Replace","VBA Code"],"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":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Usage of TRIM Function"]
[]
[null,"Movie","Year"," Trimmed"]
[null,"  Pulp   Fiction   ",1994,{"$f":"TRIM(B5)","v":"Pulp Fiction  "}]
[null," 12 Angry   Men ",1957,{"$f":"TRIM(B6)","v":"12 Angry Men"}]
[null,"The   Matrix   ",1999,"The Matrix"]
[null," Goodfellas  ",1990,"Goodfellas"]
[null,"     Seven   Samurai ",1954,"Seven Samurai"]
[null," City    of God   ",2002,"City of God"]
[null,"      Interstellar    ",2014,"Interstellar"]
[null,"    Spirited        Away ",2011,"Spirited Away"]

{"sheet":"SUBSTITUTE Function","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Usage of SUBSTITUTE Function"]
[]
[null,"Movie","Year"," Trimmed"]
[null,"  Pulp   Fiction   ",1994,{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"PulpFiction "}]
[null," 12 Angry   Men ",1957,{"$f":"SUBSTITUTE(B6,\" \",\"\")","v":"12AngryMen"}]
[null,"The   Matrix   ",1999,"TheMatrix"]
[null," Goodfellas  ",1990,"Goodfellas"]
[null,"     Seven   Samurai ",1954,"SevenSamurai"]
[null," City    of God   ",2002,"CityofGod"]
[null,"      Interstellar    ",2014,"Interstellar"]
[null,"    Spirited        Away ",2011,"SpiritedAway"]

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

{"sheet":"Find & Replace","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Usage of Find & Replace"]
[]
[null,"Movie","Year"," Trimmed"]
[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":"VBA Code","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of VBA Code"]
[]
[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]