{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RIGHT & LEN Function","Replace Function","MID & LEN Functions","Text to Columns","Flash Fill","VBA"],"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":"RIGHT & LEN Function","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Combining RIGHT & LEN Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Text String","Remove First Character",null,null,null,"Text String","Remove First Character"]
[null,"MExcel'18",{"$f":"RIGHT(B5,LEN(B5)-1)","v":"Excel'18"},null,null,null,"MExcel'18"]
[null,"MWord'18",{"$f":"RIGHT(B6,LEN(B6)-1)","v":"Word'18"},null,null,null,"MWord'18"]
[null,"MOneNote'18","OneNote'18",null,null,null,"MOneNote'18"]
[null,"MPowerPoint'18","PowerPoint'18",null,null,null,"MPowerPoint'18"]

{"sheet":"Replace Function","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Inserting REPLACE Function",null,null,null,null,"Try Yourself"]
[]
[null,"Text String","Remove First Character",null,null,null,"Text String","Remove First Character"]
[null,"MExcel'18",{"$f":"REPLACE(B5,1,1,\"\")","v":"Excel'18"},null,null,null,"MExcel'18"]
[null,"MWord'18",{"$f":"REPLACE(B6,1,1,\"\")","v":"Word'18"},null,null,null,"MWord'18"]
[null,"MOneNote'18","OneNote'18",null,null,null,"MOneNote'18"]
[null,"MPowerPoint'18","PowerPoint'18",null,null,null,"MPowerPoint'18"]

{"sheet":"MID & LEN Functions","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Nesting MID & LEN Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Text String","Remove First Character",null,null,null,"Text String","Remove First Character"]
[null,"MExcel'18",{"$f":"MID(B5,2,LEN(B5)-1)","v":"Excel'18"},null,null,null,"MExcel'18"]
[null,"MWord'18",{"$f":"MID(B6,2,LEN(B6)-1)","v":"Word'18"},null,null,null,"MWord'18"]
[null,"MOneNote'18","OneNote'18",null,null,null,"MOneNote'18"]
[null,"MPowerPoint'18","PowerPoint'18",null,null,null,"MPowerPoint'18"]

{"sheet":"Text to Columns","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Applying Text to Columns Option",null,null,null,null,"Try Yourself"]
[]
[null,"Text String","Remove First Character",null,null,null,"Text String","Remove First Character"]
[null,"MExcel'18","Excel'18",null,null,null,"MExcel'18"]
[null,"MWord'18","Word'18",null,null,null,"MWord'18"]
[null,"MOneNote'18","OneNote'18",null,null,null,"MOneNote'18"]
[null,"MPowerPoint'18","PowerPoint'18",null,null,null,"MPowerPoint'18"]

{"sheet":"Flash Fill","index":4,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Employing Flash Fill Feature",null,null,null,null,"Try Yourself"]
[]
[null,"Text String","Remove First Character",null,null,null,"Text String","Remove First Character"]
[null,"MExcel'18","Excel'18",null,null,null,"MExcel'18"]
[null,"MWord'18","Word'18",null,null,null,"MWord'18"]
[null,"MOneNote'18","OneNote'18",null,null,null,"MOneNote'18"]
[null,"MPowerPoint'18","PowerPoint'18",null,null,null,"MPowerPoint'18"]

{"sheet":"VBA","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Text String","Remove Character No","Remove First Character"]
[null,"MExcel'18",1,"Excel'18"]
[null,"MWord'18",1,"Excel'19"]
[null,"MOneNote'18",1,"Excel'20"]
[null,"MPowerPoint'18",1,"Excel'21"]