{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Find & Replace","Find & Select","Flash Fill","SUBSTITUTE Function","TEXTJOIN, MID, ROW, LEN...","TEXTJOIN, IF, ISERR, SEQUENCE..","VBA","Split Numbers And Text"],"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":"Find & Replace","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Find & Replace Tool",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID",null,null,null,"Products","Product ID"]
[null,"Black Hat ","BH23",null,null,null,"Black Hat (234)","BH23"]
[null,"Jacket ","JK56",null,null,null,"Jacket (376)","JK56"]
[null,"Shoe ","SE89",null,null,null,"Shoe (278)","SE89"]
[null,"Watch ","WH37",null,null,null,"Watch (672)","WH37"]
[null,"Red Shirt ","RS76",null,null,null,"Red Shirt (908)","RS76"]
[null,"Red Hat ","RH61",null,null,null,"Red Hat (352)","RH61"]
[null,"Black Shirt ","BS95",null,null,null,"Black Shirt (281)","BS95"]

{"sheet":"Find & Select","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Find & Select Tool",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID",null,null,null,"Products","Product ID"]
[null,"Black Hat ","BH23",null,null,null,"Black Hat ","BH23"]
[null,"Jacket ",null,null,null,null,"Jacket ",5634]
[null,"Shoe ","SE89",null,null,null,"Shoe ","SE89"]
[null,"Watch ","WH37",null,null,null,"Watch ","WH37"]
[null,"Red Shirt ",null,null,null,null,"Red Shirt ",7645]
[null,"Red Hat ","RH61",null,null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95",null,null,null,"Black Shirt ","BS95"]

{"sheet":"Flash Fill","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,1,1,3]]}
[]
[null,"Use of Flash Fill",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Output",null,null,"Products","Product ID","Output"]
[null,"Black Hat ","BH23","BH",null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56","JK",null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89","SE",null,null,"Shoe ","SE89"]
[null,"Watch ","WH37","WH",null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76","RS",null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61","RH",null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95","BS",null,null,"Black Shirt ","BS95"]

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Output",null,null,"Products","Product ID","Output"]
[null,"Black Hat ","BH23",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),0,\"\")","v":"BH"},null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),0,\"\")","v":"JK"},null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89","SE",null,null,"Shoe ","SE89"]
[null,"Watch ","WH37","WH",null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76","RS",null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61","RH",null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95","BS",null,null,"Black Shirt ","BS95"]

{"sheet":"TEXTJOIN, MID, ROW, LEN...","index":4,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of TEXTJOIN, MID, ROW, LEN, INDIRECT Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Output",null,null,"Products","Product ID","Output"]
[null,"Black Hat ","BH23",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C5,ROW(INDIRECT(\"1:\"&LEN(C5))),1)+0),MID(C5,ROW(INDIRECT(\"1:\"&LEN(C5))),1),\"\"))","v":"BH"},null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C6,ROW(INDIRECT(\"1:\"&LEN(C6))),1)+0),MID(C6,ROW(INDIRECT(\"1:\"&LEN(C6))),1),\"\"))","v":"JK"},null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C7,ROW(INDIRECT(\"1:\"&LEN(C7))),1)+0),MID(C7,ROW(INDIRECT(\"1:\"&LEN(C7))),1),\"\"))","v":"SE"},null,null,"Shoe ","SE89"]
[null,"Watch ","WH37",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C8,ROW(INDIRECT(\"1:\"&LEN(C8))),1)+0),MID(C8,ROW(INDIRECT(\"1:\"&LEN(C8))),1),\"\"))","v":"WH"},null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C9,ROW(INDIRECT(\"1:\"&LEN(C9))),1)+0),MID(C9,ROW(INDIRECT(\"1:\"&LEN(C9))),1),\"\"))","v":"RS"},null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C10,ROW(INDIRECT(\"1:\"&LEN(C10))),1)+0),MID(C10,ROW(INDIRECT(\"1:\"&LEN(C10))),1),\"\"))","v":"RH"},null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(C11,ROW(INDIRECT(\"1:\"&LEN(C11))),1)+0),MID(C11,ROW(INDIRECT(\"1:\"&LEN(C11))),1),\"\"))","v":"BS"},null,null,"Black Shirt ","BS95"]

{"sheet":"TEXTJOIN, IF, ISERR, SEQUENCE..","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of TEXTJOIN, IF, ISERR, SEQUENCE, LEN, MID Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Output",null,null,"Products","Product ID","Output"]
[null,"Black Hat ","BH23",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C5, _xlfn.SEQUENCE(LEN(C5)), 1) *1), MID(C5, _xlfn.SEQUENCE(LEN(C5)), 1), \"\"))","v":"BH"},null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C6, _xlfn.SEQUENCE(LEN(C6)), 1) *1), MID(C6, _xlfn.SEQUENCE(LEN(C6)), 1), \"\"))","v":"JK"},null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C7, _xlfn.SEQUENCE(LEN(C7)), 1) *1), MID(C7, _xlfn.SEQUENCE(LEN(C7)), 1), \"\"))","v":"SE"},null,null,"Shoe ","SE89"]
[null,"Watch ","WH37",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C8, _xlfn.SEQUENCE(LEN(C8)), 1) *1), MID(C8, _xlfn.SEQUENCE(LEN(C8)), 1), \"\"))","v":"WH"},null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C9, _xlfn.SEQUENCE(LEN(C9)), 1) *1), MID(C9, _xlfn.SEQUENCE(LEN(C9)), 1), \"\"))","v":"RS"},null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C10, _xlfn.SEQUENCE(LEN(C10)), 1) *1), MID(C10, _xlfn.SEQUENCE(LEN(C10)), 1), \"\"))","v":"RH"},null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IF(ISERROR(MID(C11, _xlfn.SEQUENCE(LEN(C11)), 1) *1), MID(C11, _xlfn.SEQUENCE(LEN(C11)), 1), \"\"))","v":"BS"},null,null,"Black Shirt ","BS95"]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of User Defined Function",null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Output",null,null,"Products","Product ID","Output"]
[null,"Black Hat ","BH23",{"$f":"RemNumb(C5)","v":"BH"},null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56",{"$f":"RemNumb(C6)","v":"JK"},null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89",{"$f":"RemNumb(C7)","v":"SE"},null,null,"Shoe ","SE89"]
[null,"Watch ","WH37",{"$f":"RemNumb(C8)","v":"WH"},null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76",{"$f":"RemNumb(C9)","v":"RS"},null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61",{"$f":"RemNumb(C10)","v":"RH"},null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95",{"$f":"RemNumb(C11)","v":"BS"},null,null,"Black Shirt ","BS95"]

{"sheet":"Split Numbers And Text","index":7,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Use of VBA to Split Numbers And Text",null,null,null,null,null,"Try Yourself"]
[]
[null,"Products","Product ID","Number","Text",null,null,"Products","Product ID","Number","Text"]
[null,"Black Hat ","BH23",{"$f":"SplitTextOrNumb(C5,1)","v":"23"},{"$f":"SplitTextOrNumb(C5,0)","v":"BH"},null,null,"Black Hat ","BH23"]
[null,"Jacket ","JK56",{"$f":"SplitTextOrNumb(C6,1)","v":"56"},{"$f":"SplitTextOrNumb(C6,0)","v":"JK"},null,null,"Jacket ","JK56"]
[null,"Shoe ","SE89",{"$f":"SplitTextOrNumb(C7,1)","v":"89"},{"$f":"SplitTextOrNumb(C7,0)","v":"SE"},null,null,"Shoe ","SE89"]
[null,"Watch ","WH37",{"$f":"SplitTextOrNumb(C8,1)","v":"37"},{"$f":"SplitTextOrNumb(C8,0)","v":"WH"},null,null,"Watch ","WH37"]
[null,"Red Shirt ","RS76",{"$f":"SplitTextOrNumb(C9,1)","v":"76"},{"$f":"SplitTextOrNumb(C9,0)","v":"RS"},null,null,"Red Shirt ","RS76"]
[null,"Red Hat ","RH61",{"$f":"SplitTextOrNumb(C10,1)","v":"61"},{"$f":"SplitTextOrNumb(C10,0)","v":"RH"},null,null,"Red Hat ","RH61"]
[null,"Black Shirt ","BS95",{"$f":"SplitTextOrNumb(C11,1)","v":"95"},{"$f":"SplitTextOrNumb(C11,0)","v":"BS"},null,null,"Black Shirt ","BS95"]