{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Dataset","Find and Replace","SUBSTITUTE","REPLACE","RIGHT, LEN","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":"Overview","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Overview of Removing Specific Characters"]
[]
[null,"Product Name","Product Code",null,"Method","Output"]
[null,"2B Pencil","#1001",null,"Find and Replace Feature","Removed Specific Characters"]
[null,"HB Pencil","#1002",null,"SUBSTITUTE Function\n=SUBSTITUTE(C5, \"*&#\", \"\")","Removed Specific Characters"]
[null,"Gel Pen","#2001",null,"REPLACE Function\n=REPLACE(C5,1,1,\"\")","Removed Specific Characters"]
[null,"Ballpoint Pen","#2002",null,"RIGHT, LEN Functions\n=RIGHT(C5,LEN(C5)-1)","Removed Specific Characters"]
[null,"Sharpner","#3001",null,"Flash Fill Feature","Removed Specific Characters"]
[null,"Eraser","#4001"]
[null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002"]

{"sheet":"Dataset","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Specific Characters"]
[]
[null,"Product Name","Product Code"]
[null,"2B Pencil","#1001"]
[null,"HB Pencil","#1002"]
[null,"Gel Pen","#2001"]
[null,"Ballpoint Pen","#2002"]
[null,"Sharpner","#3001"]
[null,"Eraser","#4001"]
[null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002"]

{"sheet":"Find and Replace","index":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Find and Replace Feature",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code",null,null,null,null,null,null,null,null,"Product Name","Product Code"]
[null,"2B Pencil",1001,null,null,null,null,null,null,null,null,"2B Pencil","#1001"]
[null,"HB Pencil",1002,null,null,null,null,null,null,null,null,"HB Pencil","#1002"]
[null,"Gel Pen",2001,null,null,null,null,null,null,null,null,"Gel Pen","#2001"]
[null,"Ballpoint Pen",2002,null,null,null,null,null,null,null,null,"Ballpoint Pen","#2002"]
[null,"Sharpner",3001,null,null,null,null,null,null,null,null,"Sharpner","#3001"]
[null,"Eraser",4001,null,null,null,null,null,null,null,null,"Eraser","#4001"]
[null,"Small Ruler",5001,null,null,null,null,null,null,null,null,"Small Ruler","#5001"]
[null,"Big Ruler",5002,null,null,null,null,null,null,null,null,"Big Ruler","#5002"]

{"sheet":"SUBSTITUTE","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code","Output",null,null,null,null,null,null,null,"Product Name","Product Code","Output"]
[null,"2B Pencil","*&#1001",{"$f":"SUBSTITUTE(C5, \"*&#\", \"\")","v":"1001"},null,null,null,null,null,null,null,"2B Pencil","*&#1001"]
[null,"HB Pencil","*&#1002",{"$f":"SUBSTITUTE(C6, \"*&#\", \"\")","v":"1002"},null,null,null,null,null,null,null,"HB Pencil","*&#1002"]
[null,"Gel Pen","*&#2001","2001",null,null,null,null,null,null,null,"Gel Pen","*&#2001"]
[null,"Ballpoint Pen","*&#2002","2002",null,null,null,null,null,null,null,"Ballpoint Pen","*&#2002"]
[null,"Sharpner","*&#3001","3001",null,null,null,null,null,null,null,"Sharpner","*&#3001"]
[null,"Eraser","*&#4001","4001",null,null,null,null,null,null,null,"Eraser","*&#4001"]
[null,"Small Ruler","*&#5001","5001",null,null,null,null,null,null,null,"Small Ruler","*&#5001"]
[null,"Big Ruler","*&#5002","5002",null,null,null,null,null,null,null,"Big Ruler","*&#5002"]

{"sheet":"REPLACE","index":4,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of REPLACE Function",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code","Output",null,null,null,null,null,null,null,"Product Name","Product Code","Output"]
[null,"2B Pencil","#1001",{"$f":"REPLACE(C5,1,1,\"\")","v":"1001"},null,null,null,null,null,null,null,"2B Pencil","#1001"]
[null,"HB Pencil","#1002",{"$f":"REPLACE(C6,1,1,\"\")","v":"1002"},null,null,null,null,null,null,null,"HB Pencil","#1002"]
[null,"Gel Pen","#2001","2001",null,null,null,null,null,null,null,"Gel Pen","#2001"]
[null,"Ballpoint Pen","#2002","2002",null,null,null,null,null,null,null,"Ballpoint Pen","#2002"]
[null,"Sharpner","#3001","3001",null,null,null,null,null,null,null,"Sharpner","#3001"]
[null,"Eraser","#4001","4001",null,null,null,null,null,null,null,"Eraser","#4001"]
[null,"Small Ruler","#5001","5001",null,null,null,null,null,null,null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002","5002",null,null,null,null,null,null,null,"Big Ruler","#5002"]

{"sheet":"RIGHT, LEN","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Combination of RIGHT and LEN Functions",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code","Output",null,null,null,null,null,null,null,"Product Name","Product Code","Output"]
[null,"2B Pencil","#1001",{"$f":"RIGHT(C5,LEN(C5)-1)","v":"1001"},null,null,null,null,null,null,null,"2B Pencil","#1001"]
[null,"HB Pencil","#1002",{"$f":"RIGHT(C6,LEN(C6)-1)","v":"1002"},null,null,null,null,null,null,null,"HB Pencil","#1002"]
[null,"Gel Pen","#2001","2001",null,null,null,null,null,null,null,"Gel Pen","#2001"]
[null,"Ballpoint Pen","#2002","2002",null,null,null,null,null,null,null,"Ballpoint Pen","#2002"]
[null,"Sharpner","#3001","3001",null,null,null,null,null,null,null,"Sharpner","#3001"]
[null,"Eraser","#4001","4001",null,null,null,null,null,null,null,"Eraser","#4001"]
[null,"Small Ruler","#5001","5001",null,null,null,null,null,null,null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002","5002",null,null,null,null,null,null,null,"Big Ruler","#5002"]

{"sheet":"Flash Fill","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Utilization of Flash Fill Feature",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code","Output",null,null,null,null,null,null,null,"Product Name","Product Code","Output"]
[null,"2B Pencil","#1001",1001,null,null,null,null,null,null,null,"2B Pencil","#1001"]
[null,"HB Pencil","#1002",1002,null,null,null,null,null,null,null,"HB Pencil","#1002"]
[null,"Gel Pen","#2001",2001,null,null,null,null,null,null,null,"Gel Pen","#2001"]
[null,"Ballpoint Pen","#2002",2002,null,null,null,null,null,null,null,"Ballpoint Pen","#2002"]
[null,"Sharpner","#3001",3001,null,null,null,null,null,null,null,"Sharpner","#3001"]
[null,"Eraser","#4001",4001,null,null,null,null,null,null,null,"Eraser","#4001"]
[null,"Small Ruler","#5001",5001,null,null,null,null,null,null,null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002",5002,null,null,null,null,null,null,null,"Big Ruler","#5002"]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Removing Unwanted Characters",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Product Name","Product Code","Output",null,null,null,null,null,null,null,"Product Name","Product Code","Output"]
[null,"2B Pencil","#1001",{"$f":"del_char(C5,\"#\")","v":"1001"},null,null,null,null,null,null,null,"2B Pencil","#1001"]
[null,"HB Pencil","#1002",{"$f":"del_char(C6,\"#\")","v":"1002"},null,null,null,null,null,null,null,"HB Pencil","#1002"]
[null,"Gel Pen","#2001",{"$f":"del_char(C7,\"#\")","v":"2001"},null,null,null,null,null,null,null,"Gel Pen","#2001"]
[null,"Ballpoint Pen","#2002",{"$f":"del_char(C8,\"#\")","v":"2002"},null,null,null,null,null,null,null,"Ballpoint Pen","#2002"]
[null,"Sharpner","#3001",{"$f":"del_char(C9,\"#\")","v":"3001"},null,null,null,null,null,null,null,"Sharpner","#3001"]
[null,"Eraser","#4001",{"$f":"del_char(C10,\"#\")","v":"4001"},null,null,null,null,null,null,null,"Eraser","#4001"]
[null,"Small Ruler","#5001",{"$f":"del_char(C11,\"#\")","v":"5001"},null,null,null,null,null,null,null,"Small Ruler","#5001"]
[null,"Big Ruler","#5002",{"$f":"del_char(C12,\"#\")","v":"5002"},null,null,null,null,null,null,null,"Big Ruler","#5002"]