{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Substitute Value","Case_sensitive","Nested Substitution","Substution Index","Replace","Nested Replace","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":"Substitute Value","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply SUBSTITUTE Function to Substitute Multiple Characters"]
[]
[null,"Original Value","Formula","Substituted Value"]
[null,"Word 2021, Word 2019","SUBSTITUTE(B5,\"Word\",\"Excel\",1)",{"$f":"SUBSTITUTE(B5,\"Word\",\"Excel\",1)","v":"Excel 2021, Word 2019"}]
[null,"Word 2021, Word 2020","SUBSTITUTE(B5,\"Word\",\"Excel\",2)",{"$f":"SUBSTITUTE(B6,\"Word\",\"Excel\",2)","v":"Word 2021, Excel 2020"}]
[null,"Word 2021, Word 2021","SUBSTITUTE(B5,\"Word\",\"Excel\")",{"$f":"SUBSTITUTE(B7,\"Word\",\"Excel\")","v":"Excel 2021, Excel 2021"}]

{"sheet":"Case_sensitive","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply SUBSTITUTE Function to Substitute Multiple Characters"]
[]
[null,"Original Value","Formula","Substituted Value"]
[null,"Word 2021, Word 2019","SUBSTITUTE(B5,\"Word\",\"Excel\",1)",{"$f":"SUBSTITUTE(B5,\"Word\",\"Excel\",1)","v":"Excel 2021, Word 2019"}]
[null,"Word 2021, Word 2020","SUBSTITUTE(B5,\"Word\",\"Excel\",2)",{"$f":"SUBSTITUTE(B6,\"Word\",\"Excel\",2)","v":"Word 2021, Excel 2020"}]
[null,"Word 2021, Word 2021","SUBSTITUTE(B5,\"Word\",\"Excel\")",{"$f":"SUBSTITUTE(B7,\"Word\",\"Excel\")","v":"Excel 2021, Excel 2021"}]
[null,"Word 2021, Word 2022","SUBSTITUTE(B5,\"word\",\"Excel\")",{"$f":"SUBSTITUTE(B5,\"word\",\"Excel\")","v":"Word 2021, Word 2019"}]

{"sheet":"Nested Substitution","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Nest SUBSTITUTE Function to Substitute Multiple Characters"]
[]
[null,"Original Value","Substituted Values"]
[null,"art. 1, amend. 2, cl. 3",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5,\"art.\",\"article\"),\"amend.\",\"amendments\"),\"cl.\",\"clause\")","v":"article 1, amendments 2, clause 3"}]
[null,"art. 1, amend. 2, cl. 4",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B6,\"art.\",\"article\"),\"amend.\",\"amendments\"),\"cl.\",\"clause\")","v":"article 1, amendments 2, clause 4"}]
[null,"art. 1, amend. 2, cl. 5","article 1, amendments 2, clause 5"]
[null,"art. 1, amend. 2, cl. 6","article 1, amendments 2, clause 6"]
[null,"art. 1, amend. 2, cl. 7","article 1, amendments 2, clause 7"]
[null,"art. 1, amend. 2, cl. 8","article 1, amendments 2, clause 8"]
[null,"art. 1, amend. 2, cl. 9","article 1, amendments 2, clause 9"]
[]
[]
[]
[]
[null,null,null,null,null,null,"  "]

{"sheet":"Substution Index","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply SUBSTITUTE Function with INDEX Function"]
[]
[null,"Orginal Value","Substituted Value",null,"Find ","Substitute"]
[null,"Red Cherries",{"$f":"SUBSTITUTE(SUBSTITUTE(B5,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"Green Cherries"},null,"Red","Green"]
[null,"Red Apples",{"$f":"SUBSTITUTE(SUBSTITUTE(B6,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"Green Apples"},null,"Blue","White"]
[null,"Red Peppers",{"$f":"SUBSTITUTE(SUBSTITUTE(B7,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"Green Peppers"}]
[null,"Blue Cheese",{"$f":"SUBSTITUTE(SUBSTITUTE(B8,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"White Cheese"}]
[null,"Blue Corn",{"$f":"SUBSTITUTE(SUBSTITUTE(B9,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"White Corn"}]
[null,"Red Chillies",{"$f":"SUBSTITUTE(SUBSTITUTE(B10,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"Green Chillies"}]
[null,"Blue Paper",{"$f":"SUBSTITUTE(SUBSTITUTE(B11,INDEX(E5:E6,1),INDEX(F5:F6,1)),INDEX(E5:E6,2),INDEX(F5:F6,2))","v":"White Paper"}]

{"sheet":"Replace","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply REPLACE Function to Substitute Multiple Characters"]
[]
[]
[null,"Original Value","Formula","Substitute Values"]
[null,"Face","REPLACE(B6, 4, 1,\"t\")",{"$f":"REPLACE(B6, 4, 1,\"t\")","v":"Fact"}]
[null,"File","REPLACE(B7, 3, 1,\"r\")",{"$f":"REPLACE(B7, 3, 1,\"r\")","v":"Fire"}]
[null,"Abase","REPLACE(B8, 5, 1,\"h\")",{"$f":"REPLACE(B8, 5, 1,\"h\")","v":"Abash"}]
[null,"chuck","REPLACE(B9, 3, 1,\"e\")",{"$f":"REPLACE(B9, 3, 1,\"e\")","v":"check"}]
[null,"Win ","REPLACE(B10, 2, 2,\"et\")",{"$f":"REPLACE(B10, 2, 2,\"et\")","v":"Wet "}]
[null,"Back","REPLACE(B11, 1, 1,\"H\")",{"$f":"REPLACE(B11, 1, 1,\"H\")","v":"Hack"}]

{"sheet":"Nested Replace","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Nest REPLACE Function to Substitute Multiple Character"]
[]
[null,"Original Value","Substituted Value"]
[null,"234-235-5689",{"$f":"REPLACE(REPLACE(B5,4,1,\" \"),8,1,\" \")","v":"234 235 5689"}]
[null,"244-245-5690","244 245 5690"]
[null,"233-239-5691","233 239 5691"]
[null,"231-235-5692","231 235 5692"]
[null,"234-235-5677","234 235 5677"]
[null,"234-235-5678","234 235 5678"]
[null,"235-235-5695","235 235 5695"]

{"sheet":"VBA","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Apply VBA Code to Substitute Multiple Character"]
[]
[null,"Original Value","Substituted Value"]
[null,"234-235-5689","234 235 5689"]