{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","TRIM Function","TRIM & SUBSTITUTE Functions","Find and Replace","REPLACE Function","VBA","Power Query","Power Query Result"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Sample Dataset","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Removing Blank Characters"]
[]
[null,"Items","Code","Status","Unit Price"]
[null,"Glazed  Donut","D03 ","Stock",2.19]
[null,"Blueberry Muffin ","M07","  En route",2.75]
[null,"Baked  Apple Pie","P02","Stock ",1.0900000000000001]
[null,"Apple   Fritter","F09  "," Factory",2.86]
[null,"Cinnamon Roll"," R05"," En route",3.22]
[null,"  Cherry Pie  ","P04","Factory",1.1200000000000001]

{"sheet":"TRIM Function","index":1,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9],[2,11,2,19]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price"]
[null,"Glazed   Donut","D03 ","Stock",2.19,null,{"$f":"TRIM(B6)","v":"Glazed Donut"},{"$f":"TRIM(C6)","v":"D03"},"Stock",2.19,null,"Glazed   Donut","D03 ","Stock",2.19,null,null,null,null,2.19]
[null,"Blueberry Muffin ","M07","  En route",2.75,null,{"$f":"TRIM(B7)","v":"Blueberry Muffin"},{"$f":"TRIM(C7)","v":"M07"},{"$f":"TRIM(D7)","v":"En route"},2.75,null,"Blueberry Muffin ","M07","  En route",2.75,null,null,null,null,2.75]
[null,"Baked   Apple Pie","P02","Stock ",1.0900000000000001,null,"Baked Apple Pie","P02","Stock",1.0900000000000001,null,"Baked   Apple Pie","P02","Stock ",1.0900000000000001,null,null,null,null,1.0900000000000001]
[null,"Apple   Fritter","F09  "," Factory",2.86,null,"Apple Fritter","F09","Factory",2.86,null,"Apple   Fritter","F09  "," Factory",2.86,null,null,null,null,2.86]
[null,"Cinnamon Roll"," R05"," En route",3.22,null,"Cinnamon Roll","R05","En route",3.22,null,"Cinnamon Roll"," R05"," En route",3.22,null,null,null,null,3.22]
[null,"  Cherry Pie  ","P04","Factory",1.1200000000000001,null,"Cherry Pie","P04","Factory",1.1200000000000001,null,"  Cherry Pie  ","P04","Factory",1.1200000000000001,null,null,null,null,1.1200000000000001]

{"sheet":"TRIM & SUBSTITUTE Functions","index":2,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9],[2,11,2,19]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price"]
[null," Glazed  Donut","D03 ","Stock",2.19,null,{"$f":"TRIM(CLEAN(SUBSTITUTE(B6,CHAR(160),\"\")))","v":"Glazed Donut"},{"$f":"TRIM(CLEAN(SUBSTITUTE(C6,CHAR(160),\"\")))","v":"D03"},"Stock",2.19,null,"Glazed   Donut","D03 ","Stock",2.19,null,null,null,null,2.19]
[null,"Blueberry Muffin ","M07","  En route",2.75,null,{"$f":"TRIM(CLEAN(SUBSTITUTE(B7,CHAR(160),\"\")))","v":"Blueberry Muffin"},{"$f":"TRIM(CLEAN(SUBSTITUTE(C7,CHAR(160),\"\")))","v":"M07"},{"$f":"TRIM(CLEAN(SUBSTITUTE(D7,CHAR(160),\"\")))","v":"En route"},2.75,null,"Blueberry Muffin ","M07","  En route",2.75,null,null,null,null,2.75]
[null,"Baked   Apple Pie","P02","Stock ",1.0900000000000001,null,"Baked Apple Pie","P02","Stock",1.0900000000000001,null,"Baked   Apple Pie","P02","Stock ",1.0900000000000001,null,null,null,null,1.0900000000000001]
[null,"Apple   Fritter","F09  "," Factory",2.86,null,"Apple Fritter","F09","Factory",2.86,null,"Apple   Fritter","F09  "," Factory",2.86,null,null,null,null,2.86]
[null,"Cinnamon Roll"," R05"," En route",3.22,null,"Cinnamon Roll","R05","En route",3.22,null,"Cinnamon Roll"," R05"," En route",3.22,null,null,null,null,3.22]
[null,"  Cherry Pie  ","P04","Factory",1.1200000000000001,null,"Cherry Pie","P04","Factory",1.1200000000000001,null,"  Cherry Pie  ","P04","Factory",1.1200000000000001,null,null,null,null,1.1200000000000001]

{"sheet":"Find and Replace","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","UnitPrice",null,"Items","Code","Status","Unit Price"]
[null,"GlazedDonut","D03","Stock",2.19,null,"Glazed  Donut","D03 ","Stock",2.19]
[null,"BlueberryMuffin","M07","Enroute",2.75,null,"Blueberry Muffin ","M07","  En route",2.75]
[null,"BakedApplePie","P02","Stock",1.0900000000000001,null,"Baked  Apple Pie","P02","Stock ",1.0900000000000001]
[null,"AppleFritter","F09","Factory",2.86,null,"Apple   Fritter","F09  "," Factory",2.86]
[null,"CinnamonRoll","R05","Enroute",3.22,null,"Cinnamon Roll"," R05"," En route",3.22]
[null,"CherryPie","P04","Factory",1.1200000000000001,null,"  Cherry Pie  ","P04","Factory",1.1200000000000001]

{"sheet":"REPLACE Function","index":4,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9],[2,11,2,19]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price"]
[null," Glazed Donut"," D03","Stock",2.19,null,{"$f":"REPLACE(B6,1,LEN(B6)-LEN(TRIM(B6)),\"\")","v":"Glazed Donut"},{"$f":"REPLACE(C6,1,LEN(C6)-LEN(TRIM(C6)),\"\")","v":"D03"},"Stock",2.19,null,"Glazed   Donut","D03 ","Stock",2.19,null,null,null,null,2.19]
[null,"  Blueberry Muffin","M07","  En route",2.75,null,{"$f":"REPLACE(B7,1,LEN(B7)-LEN(TRIM(B7)),\"\")","v":"Blueberry Muffin"},{"$f":"REPLACE(C7,1,LEN(C7)-LEN(TRIM(C7)),\"\")","v":"M07"},{"$f":"REPLACE(D7,1,LEN(D7)-LEN(TRIM(D7)),\"\")","v":"En route"},2.75,null,"Blueberry Muffin ","M07","  En route",2.75,null,null,null,null,2.75]
[null,"  Baked Apple Pie","P02"," Stock",1.0900000000000001,null,"Baked Apple Pie","P02","Stock",1.0900000000000001,null,"Baked   Apple Pie","P02","Stock ",1.0900000000000001,null,null,null,null,1.0900000000000001]
[null,"        Apple Fritter","    F09"," Factory",2.86,null,"Apple Fritter","F09","Factory",2.86,null,"Apple   Fritter","F09  "," Factory",2.86,null,null,null,null,2.86]
[null,"Cinnamon Roll"," R05","  En route",3.22,null,"Cinnamon Roll","R05","En route",3.22,null,"Cinnamon Roll"," R05"," En route",3.22,null,null,null,null,3.22]
[null,"    Cherry Pie","P04","Factory",1.1200000000000001,null,"Cherry Pie","P04","Factory",1.1200000000000001,null,"  Cherry Pie  ","P04","Factory",1.1200000000000001,null,null,null,null,1.1200000000000001]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price"]
[null,"Glazed Donut","D03","Stock",2.19,null,"    Glazed Donut","    D03"," Stock",2.19]
[null,"Blueberry Muffin","M07","En route",2.75,null," Blueberry Muffin"," M07","  En route",2.75]
[null,"Baked Apple Pie","P02","Stock",1.0900000000000001,null," Baked Apple Pie"," P02","Stock",1.0900000000000001]
[null,"Apple Fritter","F09","Factory",2.86,null,"      Apple Fritter","F09","   Factory",2.86]
[null,"Cinnamon Roll","R05","En route",3.22,null,"   Cinnamon Roll","      R05","En route",3.22]
[null,"Cherry Pie","P04","Factory",1.1200000000000001,null,"Cherry Pie","   P04","    Factory",1.1200000000000001]

{"sheet":"Power Query","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Removing Blank Characters",null,null,null,null,"Practice"]
[]
[null,"Items","Code","Status","Unit Price",null,"Items","Code","Status","Unit Price"]
[null,"   Glazed Donut","D03"," Stock",2.19,null,"   Glazed Donut","D03"," Stock",2.19]
[null," Blueberry Muffin","   M07","  En route",2.75,null," Blueberry Muffin","   M07","  En route",2.75]
[null," Baked Apple Pie","P02","Stock",1.0900000000000001,null," Baked Apple Pie","P02","Stock",1.0900000000000001]
[null,"     Apple Fritter"," F09","  Factory",2.86,null,"     Apple Fritter"," F09","  Factory",2.86]
[null," Cinnamon Roll"," R05"," En route",3.22,null," Cinnamon Roll"," R05"," En route",3.22]
[null,"  Cherry Pie","P04"," Factory",1.1200000000000001,null,"  Cherry Pie","P04"," Factory",1.1200000000000001]

{"sheet":"Power Query Result","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Items","Code","Status","Unit Price"]
[null,"Glazed Donut","D03","Stock",2.19]
[null,"Blueberry Muffin","M07","En route",2.75]
[null,"Baked Apple Pie","P02","Stock",1.0900000000000001]
[null,"Apple Fritter","F09","Factory",2.86]
[null,"Cinnamon Roll","R05","En route",3.22]
[null,"Cherry Pie","P04","Factory",1.1200000000000001]