{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Price List","Find & Replace","SUBSTITUTE Function","VBA","LEFT And FIND Functions"],"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":"Price List","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Price List"]
[]
[null,"Product ID","Price"]
[null,"Carrot-(234)",20]
[null,"Apple-(376)",15]
[null,"Orange-(278)",12]
[null,"Guava-(672)",16]
[null,"Lemon-(908)",13]
[null,"Grape-(352)",17]
[null,"Banana-(281)",14]

{"sheet":"Find & Replace","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Find & Replace",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Price",null,null,null,null,null,"Product ID","Price"]
[null,"Carrot-234",20,null,null,null,null,null,"Carrot-(234)",20]
[null,"Apple-376",15,null,null,null,null,null,"Apple-(376)",15]
[null,"Orange-278",12,null,null,null,null,null,"Orange-(278)",12]
[null,"Guava-672",16,null,null,null,null,null,"Guava-(672)",16]
[null,"Lemon-908",13,null,null,null,null,null,"Lemon-(908)",13]
[null,"Grape-352",17,null,null,null,null,null,"Grape-(352)",17]
[null,"Banana-281",14,null,null,null,null,null,"Banana-(281)",14]

{"sheet":"SUBSTITUTE Function","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Inserting SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Price","Output 1","Output 2",null,null,null,null,null,null,"Product ID","Price","Output 1","Output 2"]
[null,"Carrot-(234)",20,{"$f":"SUBSTITUTE(B5,\"(\",\"\")","v":"Carrot-234)"},{"$f":"SUBSTITUTE(D5,\")\",\"\")","v":"Carrot-234"},null,null,null,null,null,null,"Carrot-(234)",20]
[null,"Apple-(376)",15,{"$f":"SUBSTITUTE(B6,\"(\",\"\")","v":"Apple-376)"},{"$f":"SUBSTITUTE(D6,\")\",\"\")","v":"Apple-376"},null,null,null,null,null,null,"Apple-(376)",15]
[null,"Orange-(278)",12,"Orange-278)","Orange-278",null,null,null,null,null,null,"Orange-(278)",12]
[null,"Guava-(672)",16,"Guava-672)","Guava-672",null,null,null,null,null,null,"Guava-(672)",16]
[null,"Lemon-(908)",13,"Lemon-908)","Lemon-908",null,null,null,null,null,null,"Lemon-(908)",13]
[null,"Grape-(352)",17,"Grape-352)","Grape-352",null,null,null,null,null,null,"Grape-(352)",17]
[null,"Banana-(281)",14,"Banana-281)","Banana-281",null,null,null,null,null,null,"Banana-(281)",14]

{"sheet":"VBA","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Price",null,null,null,null,null,null,"Product ID","Price"]
[null,"Carrot-234",20,null,null,null,null,null,null,"Carrot-(234)",20]
[null,"Apple-376",15,null,null,null,null,null,null,"Apple-(376)",15]
[null,"Orange-278",12,null,null,null,null,null,null,"Orange-(278)",12]
[null,"Guava-672",16,null,null,null,null,null,null,"Guava-(672)",16]
[null,"Lemon-908",13,null,null,null,null,null,null,"Lemon-(908)",13]
[null,"Grape-352",17,null,null,null,null,null,null,"Grape-(352)",17]
[null,"Banana-281",14,null,null,null,null,null,null,"Banana-(281)",14]

{"sheet":"LEFT And FIND Functions","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Combining LEFT And FIND Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product ID","Price","Output",null,null,null,null,"Product ID","Price","Output"]
[null,"Carrot(234)",20,{"$f":"LEFT(B5,FIND(\"(\",B5,1)-1)","v":"Carrot"},null,null,null,null,"Carrot(234)",20]
[null,"Apple(376)",15,{"$f":"LEFT(B6,FIND(\"(\",B6,1)-1)","v":"Apple"},null,null,null,null,"Apple(376)",15]
[null,"Orange(278)",12,"Orange",null,null,null,null,"Orange(278)",12]
[null,"Guava(672)",16,"Guava",null,null,null,null,"Guava(672)",16]
[null,"Lemon(908)",13,"Lemon",null,null,null,null,"Lemon(908)",13]
[null,"Grape(352)",17,"Grape",null,null,null,null,"Grape(352)",17]
[null,"Banana(281)",14,"Banana",null,null,null,null,"Banana(281)",14]