{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Using TRIM for String ","Using TRIM for Numeric Values","Using LEFT TRIM","Using SUBSTITUTE","Using TRIM & SUBSTITUTE","Using Find & Replace","VBA to  Trim Leading Spaces","VBA to Trim Trailing Spaces","Practice Section"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code"]
[null,"   Adam     Smith","Fl orida","    1001"]
[null,"Jim     Carry","Californ   ia","   2005"]
[null,"      Rachel Ross","Miami","      3100"]
[null,"Victor    Rosario      ","Ch  ica go",1201]
[null,"        Kristin       Moran","Wash  ington","  4321"]
[null,"  Jonas     Moran","California","      4001"]
[null,"Monica   Rosario","Miami","  5001"]
[null,"       Scott Murdock","  Ho  uston","    6002"]
[null,"Jade      Vega","   Texa s","         2301"]

{"sheet":"Using TRIM for String ","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code","Trim Spaces"]
[null,"   Adam     Smith","Fl orida","    1001",{"$f":"TRIM(B4)","v":"Adam Smith"}]
[null,"Jim     Carry","Californ   ia","   2005",{"$f":"TRIM(B5)","v":"Jim Carry"}]
[null,"      Rachel Ross","Miami","      3100","Rachel Ross"]
[null,"Victor    Rosario      ","Ch  ica go",1201,"Victor Rosario"]
[null,"        Kristin       Moran","Wash  ington","  4321","Kristin Moran"]
[null,"  Jonas     Moran","California","      4001","Jonas Moran"]
[null,"Monica   Rosario","Miami","  5001","Monica Rosario"]
[null,"       Scott Murdock","  Ho  uston","    6002","Scott Murdock"]
[null,"Jade      Vega","   Texa s","         2301","Jade Vega"]

{"sheet":"Using TRIM for Numeric Values","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code","Trim Spaces","Trim Spaces From #"]
[null,"   Adam     Smith","Fl orida","    1001   ",{"$f":"TRIM(D4)","v":"1001"},{"$f":"VALUE(TRIM(D4))","v":1001}]
[null,"Jim     Carry","Californ   ia","   2005   ",{"$f":"TRIM(D5)","v":"2005"},{"$f":"VALUE(TRIM(D5))","v":2005}]
[null,"      Rachel Ross","Miami","      3100","3100",3100]
[null,"Victor    Rosario      ","Ch  ica go",1201,"1201",1201]
[null,"        Kristin       Moran","Wash  ington","  4321","4321",4321]
[null,"  Jonas     Moran","California","      4001","4001",4001]
[null,"Monica   Rosario","Miami","  5001","5001",5001]
[null,"       Scott Murdock","  Ho  uston","    6002","6002",6002]
[null,"Jade      Vega","   Texa s","         2301","2301",2301]

{"sheet":"Using LEFT TRIM","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code","Trim Spaces"]
[null,"   Adam     Smith","Fl orida","    1001",{"$f":"MID(B4,FIND(MID(TRIM(B4),1,1),B4),LEN(B4))","v":"Adam     Smith"}]
[null,"Jim     Carry","Californ   ia","   2005",{"$f":"MID(B5,FIND(MID(TRIM(B5),1,1),B5),LEN(B5))","v":"Jim     Carry"}]
[null,"      Rachel Ross","Miami","      3100",{"$f":"MID(B6,FIND(MID(TRIM(B6),1,1),B6),LEN(B6))","v":"Rachel Ross"}]
[null,"Victor    Rosario      ","Ch  ica go",1201,"Victor    Rosario      "]
[null,"        Kristin       Moran","Wash  ington","  4321","Kristin       Moran"]
[null,"  Jonas     Moran","California","      4001","Jonas     Moran"]
[null,"Monica   Rosario","Miami","  5001","Monica   Rosario"]
[null,"       Scott Murdock","  Ho  uston","    6002","Scott Murdock"]
[null,"Jade      Vega","   Texa s","         2301","Jade      Vega"]

{"sheet":"Using SUBSTITUTE","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code","Trim Spaces"]
[null,"   Adam     Smith","Fl orida","    1001",{"$f":"SUBSTITUTE(C4,\" \",\"\")","v":"Florida"}]
[null,"Jim     Carry","Californ   ia","   2005",{"$f":"SUBSTITUTE(C5,\" \",\"\")","v":"California"}]
[null,"      Rachel Ross","Miami","      3100","Miami"]
[null,"Victor    Rosario      ","Ch  ica go",1201,"Chicago"]
[null,"        Kristin       Moran","Wash  ington","  4321","Washington"]
[null,"  Jonas     Moran","California","      4001","California"]
[null,"Monica   Rosario","Miami","  5001","Miami"]
[null,"       Scott Murdock","  Ho  uston","    6002","Houston"]
[null,"Jade      Vega","   Texa s","         2301","Texas"]

{"sheet":"Using TRIM & SUBSTITUTE","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code","Trim Spaces"]
[null,"   Adam     Smith","Fl orida","    1001     ",{"$f":"TRIM(\"   Adam     Smith\")","v":"Adam Smith"}]
[null,"Jim     Carry","Californ   ia","   2005",{"$f":"TRIM(CLEAN((SUBSTITUTE(B5,CHAR(160),\" \"))))","v":"Jim Carry"}]
[null,"      Rachel Ross","Miami","      3100","Rachel Ross"]
[null,"Victor    Rosario      ","Ch  ica go",1201,"Victor Rosario"]
[null,"        Kristin       Moran","Wash  ington","  4321","Kristin Moran"]
[null,"  Jonas     Moran","California","      4001","Jonas Moran"]
[null,"Monica   Rosario","Miami","  5001","Monica Rosario"]
[null,"       Scott Murdock","  Ho  uston","    6002","Scott Murdock"]
[null,"Jade      Vega","   Texa s","         2301","Jade Vega"]

{"sheet":"Using Find & Replace","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code"]
[null,"   Adam     Smith","Florida","    1001"]
[null,"Jim     Carry","California","   2005"]
[null,"      Rachel Ross","Miami","      3100"]
[null,"Victor    Rosario      ","Chicago",1201]
[null,"        Kristin       Moran","Washington","  4321"]
[null,"  Jonas     Moran","California","      4001"]
[null,"Monica   Rosario","Miami","  5001"]
[null,"       Scott Murdock","Houston","    6002"]
[null,"Jade      Vega","Texas","         2301"]

{"sheet":"VBA to  Trim Leading Spaces","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code"]
[null,"Adam     Smith","Fl orida","    1001"]
[null,"Jim     Carry","Californ   ia","   2005"]
[null,"Rachel Ross","Miami","      3100"]
[null,"Victor    Rosario      ","Ch  ica go",1201]
[null,"Kristin       Moran","Wash  ington","  4321"]
[null,"Jonas     Moran","California","      4001"]
[null,"Monica   Rosario","Miami","  5001"]
[null,"Scott Murdock","  Ho  uston","    6002"]
[null,"Jade      Vega","   Texa s","         2301"]

{"sheet":"VBA to Trim Trailing Spaces","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Excel Trim Spaces"]
[]
[null,"Name","City","ZIP Code"]
[null,"Adam Smith","Fl orida","    1001"]
[null,"Jim Carry","Californ   ia","   2005"]
[null,"Rachel Ross","Miami","      3100"]
[null,"Victor Rosario","Ch  ica go",1201]
[null,"Kristin Moran","Wash  ington","  4321"]
[null,"Jonas Moran","California","      4001"]
[null,"Monica Rosario","Miami","  5001"]
[null,"Scott Murdock","Ho  uston","    6002"]
[null,"Jade Vega","Texa s","         2301"]

{"sheet":"Practice Section","index":9,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it YourSelf"]
[]
[null,"Name","City","ZIP Code","Trim Spaces"]
[null,"   Adam     Smith","Fl orida","    1001"]
[null,"Jim     Carry","Californ   ia","   2005"]
[null,"      Rachel Ross","Miami","      3100"]
[null,"Victor    Rosario      ","Ch  ica go",1201]
[null,"        Kristin       Moran","Wash  ington","  4321"]
[null,"  Jonas     Moran","California","      4001"]
[null,"Monica   Rosario","Miami","  5001"]
[null,"       Scott Murdock","  Ho  uston","    6002"]
[null,"Jade      Vega","   Texa s","         2301"]