{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","TRIM","Find & Replace","SBSTITUTE","VBA","Power Query","Table1","Delimited"],"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":"Dataset","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Producr Name","Product Code"]
[null,"Product-1","1567      BXTW"]
[null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428         CEPT"]
[null,"Product-4","        2597     RPLX"]

{"sheet":"TRIM","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of TRIM Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Producr Name","Product Code","Cleaned Value",null,null,"Producr Name","Product Code","Cleaned Value"]
[null,"Product-1","1567      BXTW",{"$f":"TRIM(C5)","v":"1567 BXTW"},null,null,"Product-1","1567      BXTW"]
[null,"Product-2","   2487 DRTW",{"$f":"TRIM(C6)","v":"2487 DRTW"},null,null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428         CEPT","8428 CEPT",null,null,"Product-3","8428         CEPT"]
[null,"Product-4","        2597     RPLX","2597 RPLX",null,null,"Product-4","        2597     RPLX"]

{"sheet":"Find & Replace","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Find & Replace Options",null,null,"Practice Yourself"]
[]
[null,"Producr Name","Product Code",null,"Producr Name","Product Code"]
[null,"Product-1","1567BXTW",null,"Product-1","1567      BXTW"]
[null,"Product-2","2487DRTW",null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428CEPT",null,"Product-3","8428         CEPT"]
[null,"Product-4","2597RPLX",null,"Product-4","        2597     RPLX"]

{"sheet":"SBSTITUTE","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Producr Name","Product Code","Cleaned Value",null,null,"Producr Name","Product Code","Cleaned Value"]
[null,"Product-1","1567      BXTW",{"$f":"SUBSTITUTE(C5,\" \",\"\")","v":"1567BXTW"},null,null,"Product-1","1567      BXTW"]
[null,"Product-2","   2487 DRTW",{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"2487DRTW"},null,null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428         CEPT","8428CEPT",null,null,"Product-3","8428         CEPT"]
[null,"Product-4","        2597     RPLX","2597RPLX",null,null,"Product-4","        2597     RPLX"]

{"sheet":"VBA","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of VBA",null,null,null,"Practice Yourself"]
[]
[null,"Producr Name","Product Code",null,null,"Producr Name","Product Code"]
[null,"Product-1","1567BXTW",null,null,"Product-1","1567      BXTW"]
[null,"Product-2","2487DRTW",null,null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428CEPT",null,null,"Product-3","8428         CEPT"]
[null,"Product-4","2597RPLX",null,null,"Product-4","        2597     RPLX"]

{"sheet":"Power Query","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Query"]
[]
[null,"Column1","Column2"]
[null,"Producr Name","Product Code"]
[null,"Product-1","1567      BXTW"]
[null,"Product-2","   2487 DRTW"]
[null,"Product-3","8428         CEPT"]
[null,"Product-4","        2597     RPLX"]

{"sheet":"Table1","index":6,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Column1","Column2"]
["Producr Name","ProductCode"]
["Product-1","1567BXTW"]
["Product-2","2487DRTW"]
["Product-3","8428CEPT"]
["Product-4","2597RPLX"]

{"sheet":"Delimited","index":7,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Delimited Option",null,null,null,null,"Practice Yourself"]
[]
[null,"Producr Name","Product Code",null,null,null,"Producr Name","Product Code"]
[null,"Product-1","BXTW",1567,null,null,"Product-1","1567      BXTW"]
[null,"Product-2","DRTW",2487,null,null,"Product-2","   2487 DRTW"]
[null,"Product-3","CEPT",8428,null,null,"Product-3","8428         CEPT"]
[null,"Product-4","RPLX",2597,null,null,"Product-4","        2597     RPLX"]