{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Find and Replace Tool","SUBSTITUTE Function","REPLACE Function","MID and LEN Functions","RIGHT and LEN Functions","LEFT and FIND Functions","nth Instance","Flash Fill","VBA Method"],"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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Text From Excel Cell"]
[]
[null,"Product Name","Product ID"]
[null,"Hat","ID1001"]
[null,"Jacket","ID1002"]
[null,"Shoe","ID1003"]
[null,"Watch","ID1004"]
[null,"Shirt","ID1005"]

{"sheet":"Find and Replace Tool","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of Find and Replace Tool",null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product  ",null,null,null,null,null,null,null,"Product Name","Product ID"]
[null,"Hat",1001,null,null,null,null,null,null,null,"Hat","ID1001"]
[null,"Jacket",1002,null,null,null,null,null,null,null,"Jacket","ID1002"]
[null,"Shoe",1003,null,null,null,null,null,null,null,"Shoe","ID1003"]
[null,"Watch",1004,null,null,null,null,null,null,null,"Watch","ID1004"]
[null,"Shirt",1005,null,null,null,null,null,null,null,"Shirt","ID1005"]

{"sheet":"SUBSTITUTE Function","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","ID1001",{"$f":"SUBSTITUTE(C5,\"ID\",\"\")","v":"1001"},null,null,null,null,null,"Hat","ID1001",{"$f":"SUBSTITUTE(K5,\"ID\",\"\")","v":"1001"}]
[null,"Jacket","ID1002",{"$f":"SUBSTITUTE(C6,\"ID\",\"\")","v":"1002"},null,null,null,null,null,"Jacket","ID1002",{"$f":"SUBSTITUTE(K6,\"ID\",\"\")","v":"1002"}]
[null,"Shoe","ID1003","1003",null,null,null,null,null,"Shoe","ID1003","1003"]
[null,"Watch","ID1004","1004",null,null,null,null,null,"Watch","ID1004","1004"]
[null,"Shirt","ID1005","1005",null,null,null,null,null,"Shirt","ID1005","1005"]

{"sheet":"REPLACE Function","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying REPLACE Function",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","ID1001",{"$f":"REPLACE(C5,1,2,\"\")","v":"1001"},null,null,null,null,null,"Hat","ID1001"]
[null,"Jacket","ID1002",{"$f":"REPLACE(C6,1,2,\"\")","v":"1002"},null,null,null,null,null,"Jacket","ID1002"]
[null,"Shoe","ID1003","1003",null,null,null,null,null,"Shoe","ID1003"]
[null,"Watch","ID1004","1004",null,null,null,null,null,"Watch","ID1004"]
[null,"Shirt","ID1005","1005",null,null,null,null,null,"Shirt","ID1005"]

{"sheet":"MID and LEN Functions","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Combination of MID and LEN Functions",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","ID1001",{"$f":"MID(C5,3,LEN(C5)-2)","v":"1001"},null,null,null,null,"Hat","ID1001"]
[null,"Jacket","ID1002",{"$f":"MID(C6,3,LEN(C6)-2)","v":"1002"},null,null,null,null,"Jacket","ID1002"]
[null,"Shoe","ID1003","1003",null,null,null,null,"Shoe","ID1003"]
[null,"Watch","ID1004","1004",null,null,null,null,"Watch","ID1004"]
[null,"Shirt","ID1005","1005",null,null,null,null,"Shirt","ID1005"]

{"sheet":"RIGHT and LEN Functions","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Merging RIGHT and LEN Functions",null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","ID1001",{"$f":"RIGHT(C5,LEN(C5)-2)","v":"1001"},null,null,null,null,null,null,"Hat","ID1001"]
[null,"Jacket","ID1002",{"$f":"RIGHT(C6,LEN(C6)-2)","v":"1002"},null,null,null,null,null,null,"Jacket","ID1002"]
[null,"Shoe","ID1003","1003",null,null,null,null,null,null,"Shoe","ID1003"]
[null,"Watch","ID1004","1004",null,null,null,null,null,null,"Watch","ID1004"]
[null,"Shirt","ID1005","1005",null,null,null,null,null,null,"Shirt","ID1005"]

{"sheet":"LEFT and FIND Functions","index":6,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of LEFT and FIND Functions",null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","1001#ID",{"$f":"LEFT(C5,FIND(\"#\",C5)-1)","v":"1001"},null,null,null,null,null,null,"Hat","1001#ID"]
[null,"Jacket","1002#ID",{"$f":"LEFT(C6,FIND(\"#\",C6)-1)","v":"1002"},null,null,null,null,null,null,"Jacket","1002#ID"]
[null,"Shoe","1003#ID","1003",null,null,null,null,null,null,"Shoe","1003#ID"]
[null,"Watch","1004#ID","1004",null,null,null,null,null,null,"Watch","1004#ID"]
[null,"Shirt","1005#ID","1005",null,null,null,null,null,null,"Shirt","1005#ID"]

{"sheet":"nth Instance","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Removing nth Instance",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","1001#ID#P",{"$f":"SUBSTITUTE(C5,\"#\",\"\",1)","v":"1001ID#P"},null,null,null,null,"Hat","1001#ID#P"]
[null,"Jacket","1002#ID#P",{"$f":"SUBSTITUTE(C6,\"#\",\"\",1)","v":"1002ID#P"},null,null,null,null,"Jacket","1002#ID#P"]
[null,"Shoe","1003#ID#P","1003ID#P",null,null,null,null,"Shoe","1003#ID#P"]
[null,"Watch","1004#ID#P","1004ID#P",null,null,null,null,"Watch","1004#ID#P"]
[null,"Shirt","1005#ID#P","1005ID#P",null,null,null,null,"Shirt","1005#ID#P"]

{"sheet":"Flash Fill","index":8,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Applying Flash Fill",null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","1001#ID",1001,null,null,null,{"$f":"FIND(\"#\",C5)","v":5},null,null,null,"Hat","1001#ID"]
[null,"Jacket","1002#ID",1002,null,null,null,null,null,null,null,"Jacket","1002#ID"]
[null,"Shoe","1003#ID",1003,null,null,null,null,null,null,null,"Shoe","1003#ID"]
[null,"Watch","1004#ID",1004,null,null,null,null,null,null,null,"Watch","1004#ID"]
[null,"Shirt","1005#ID",1005,null,null,null,null,null,null,null,"Shirt","1005#ID"]

{"sheet":"VBA Method","index":9,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product Name","Product ID","Result",null,null,null,null,null,null,"Product Name","Product ID","Result"]
[null,"Hat","1001#ID",1001,null,null,null,null,null,null,"Hat","1001#ID"]
[null,"Jacket","1002#ID",1002,null,null,null,null,null,null,"Jacket","1002#ID"]
[null,"Shoe","1003#ID",1003,null,null,null,null,null,null,"Shoe","1003#ID"]
[null,"Watch","1004#ID",1004,null,null,null,null,null,null,"Watch","1004#ID"]
[null,"Shirt","1005#ID",1005,null,null,null,null,null,null,"Shirt","1005#ID"]