{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Dataset","TRIM Function","SUBSTITUTE Function","CLEAN with TRIM Function","TRIM, CLEAN, and SUBSTITUTE","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":"Overview","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,1,16,1],[17,1,19,1],[1,1,1,3]]}
[]
[null,"Removing Spaces in Cell"]
[]
[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"]
[]
[null,"Remove Type","Output","Function"]
[null,"All Spaces",{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"PulpFiction "},{"$f":"_xlfn.FORMULATEXT(C15)","v":"=SUBSTITUTE(B5,\" \",\"\")"}]
[null,null,"PulpFiction ","Find and Repace Command"]
[null,null,{"$f":"removing_space(B5)","v":"PulpFiction "},{"$f":"_xlfn.FORMULATEXT(C17)","v":"=removing_space(B5)"}]
[null,"Extra Spaces",{"$f":"TRIM(B5)","v":"Pulp Fiction  "},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=TRIM(B5)"}]
[null,null,{"$f":"TRIM(CLEAN(B5))","v":"Pulp Fiction  "},{"$f":"_xlfn.FORMULATEXT(C19)","v":"=TRIM(CLEAN(B5))"}]
[null,null,{"$f":"TRIM(CLEAN((SUBSTITUTE(B5,\" \",\" \"))))","v":"Pulp Fiction  "},"=TRIM(CLEAN((SUBSTITUTE(B5,\" \",\" \"))))"]

{"sheet":"Dataset","index":1,"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":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using TRIM Function to Remove Spaces in Cell",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Movie","Year"," Trimmed",null,null,null,null,null,null,"Movie","Year"," Trimmed"]
[null,"  Pulp   Fiction   ",1994,{"$f":"TRIM(B5)","v":"Pulp Fiction  "},null,null,null,null,null,null,"  Pulp   Fiction   ",1994]
[null," 12 Angry   Men ",1957,{"$f":"TRIM(B6)","v":"12 Angry Men"},null,null,null,null,null,null," 12 Angry   Men ",1957]
[null,"The   Matrix   ",1999,"The Matrix",null,null,null,null,null,null,"The   Matrix   ",1999]
[null," Goodfellas  ",1990,"Goodfellas",null,null,null,null,null,null," Goodfellas  ",1990]
[null,"     Seven   Samurai ",1954,"Seven Samurai",null,null,null,null,null,null,"     Seven   Samurai ",1954]
[null," City    of God   ",2002,"City of God",null,null,null,null,null,null," City    of God   ",2002]
[null,"      Interstellar    ",2014,"Interstellar",null,null,null,null,null,null,"      Interstellar    ",2014]
[null,"    Spirited        Away ",2011,"Spirited Away",null,null,null,null,null,null,"    Spirited        Away ",2011]

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

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

{"sheet":"TRIM, CLEAN, and SUBSTITUTE","index":5,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Implementing TRIM, CLEAN, and SUBSTITUTE Functions",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Movie","Year"," Trimmed",null,null,null,null,null,null,"Movie","Year"," Trimmed"]
[null,"  Pulp   Fiction   ",1994,{"$f":"TRIM(CLEAN((SUBSTITUTE(B5,\" \",\" \"))))","v":"Pulp Fiction  "},null,null,null,null,null,null,"  Pulp   Fiction   ",1994]
[null," 12 Angry   Men ",1957,{"$f":"TRIM(CLEAN((SUBSTITUTE(B6,\" \",\" \"))))","v":"12 Angry Men"},null,null,null,null,null,null," 12 Angry   Men ",1957]
[null,"The   Matrix   ",1999,"The Matrix",null,null,null,null,null,null,"The   Matrix   ",1999]
[null," Goodfellas  ",1990,"Goodfellas",null,null,null,null,null,null," Goodfellas  ",1990]
[null,"     Seven   Samurai ",1954,"Seven Samurai",null,null,null,null,null,null,"     Seven   Samurai ",1954]
[null," City    of God   ",2002,"City of God",null,null,null,null,null,null," City    of God   ",2002]
[null,"      Interstellar    ",2014,"Interstellar",null,null,null,null,null,null,"      Interstellar    ",2014]
[null,"    Spirited        Away ",2011,"Spirited Away",null,null,null,null,null,null,"    Spirited        Away ",2011]

{"sheet":"Find & Replace","index":6,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Removing Spaces in Cell Using Find and Replace Feature",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Movie","Year"," Trimmed",null,null,null,null,null,null,"Movie","Year"," Trimmed"]
[null,"Pulp    Fiction  ",1994,"PulpFiction ",null,null,null,null,null,null,"  Pulp   Fiction   ",1994]
[null,"12    Angry Men",1957,"12AngryMen",null,null,null,null,null,null," 12 Angry   Men ",1957]
[null,"The    Matrix",1999,"TheMatrix",null,null,null,null,null,null,"The   Matrix   ",1999]
[null,"Goodfellas",1990,"Goodfellas",null,null,null,null,null,null," Goodfellas  ",1990]
[null,"Seven    Samurai",1954,"SevenSamurai",null,null,null,null,null,null,"     Seven   Samurai ",1954]
[null,"City    of    God",2002,"CityofGod",null,null,null,null,null,null," City    of God   ",2002]
[null,"Interstellar",2014,"Interstellar",null,null,null,null,null,null,"      Interstellar    ",2014]
[null,"Spirited Away",2011,"SpiritedAway",null,null,null,null,null,null,"    Spirited        Away ",2011]

{"sheet":"VBA Code","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Incorporating VBA Code to Remove Spaces",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Movie","Year"," Trimmed",null,null,null,null,null,null,"Movie","Year"," Trimmed"]
[null,"Pulp    Fiction  ",1994,{"$f":"removing_space(B5)","v":"PulpFiction "},null,null,null,null,null,null,"  Pulp   Fiction   ",1994]
[null,"12    Angry Men",1957,{"$f":"removing_space(B6)","v":"12AngryMen"},null,null,null,null,null,null," 12 Angry   Men ",1957]
[null,"The    Matrix",1999,{"$f":"removing_space(B7)","v":"TheMatrix"},null,null,null,null,null,null,"The   Matrix   ",1999]
[null,"Goodfellas",1990,{"$f":"removing_space(B8)","v":"Goodfellas"},null,null,null,null,null,null," Goodfellas  ",1990]
[null,"Seven    Samurai",1954,{"$f":"removing_space(B9)","v":"SevenSamurai"},null,null,null,null,null,null,"     Seven   Samurai ",1954]
[null,"City    of    God",2002,{"$f":"removing_space(B10)","v":"CityofGod"},null,null,null,null,null,null," City    of God   ",2002]
[null,"Interstellar",2014,{"$f":"removing_space(B11)","v":"Interstellar"},null,null,null,null,null,null,"      Interstellar    ",2014]
[null,"Spirited Away",2011,{"$f":"removing_space(B12)","v":"SpiritedAway"},null,null,null,null,null,null,"    Spirited        Away ",2011]