{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["VBA","IFNA VLOOK ","Lambda","XLOOKUP","Find and Select Tool","Substitute","Replace"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"VBA","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"Source Data Values",null,"Find","Replace"]
[null,"2013-John-xgb",null,2010,2013]
[null,"2018-Carlos-zxg",null,2012,2015]
[null,"2018-Ronaldo-xgb",null,2015,2018]
[null,"2013-Lia-zgb",null,2019,2021]
[null,"2018-Iniesta-xww"]
[null,"2013-Jake-rrt"]
[null,"2021-Leon-xfg"]

{"sheet":"IFNA VLOOK ","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"Source Data Values","Result After Replacing ","Old","Replace with"]
[null,"NJ",{"$f":"_xlfn.IFNA(VLOOKUP($B6,$D$6:$E$9, 2, FALSE), B6)","v":"New Jersey"},"NJ","New Jersey"]
[null,"NC",{"$f":"_xlfn.IFNA(VLOOKUP($B7,$D$6:$E$9, 2, FALSE), B7)","v":"NC"},"Ga","Georgia"]
[null,"CA","California","CA","California"]
[null,"HI","Hawaii","HI","Hawaii"]
[null,"MS","MS"]
[null,"Ga","Georgia"]
[null,"MO","MO"]

{"sheet":"Lambda","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"Source Data values","Result After Replacing ","Old","Replace with"]
[null,"NY, NJ",{"$f":"MultiReplace(\nB6:B12,$D$6,$E$6)","v":"NY, New Jersey"},"NJ","New Jersey"]
[null,"NC, NJ",{"$f":"MultiReplace(\nB7:B13,$D$6,$E$6)","v":"NC, New Jersey"},"Ga","Georgia"]
[null,"GA, CA",{"$f":"MultiReplace(\nB8:B14,$D$6,$E$6)","v":"GA, California"},"CA","California"]
[null,"HI, ID",{"$f":"MultiReplace(\nB9:B15,$D$6,$E$6)","v":"Hawaii, ID"},"HI","Hawaii"]
[null,"MS, CA",{"$f":"MultiReplace(\nB10:B16,$D$6,$E$6)","v":"MS, California"}]
[null,"NJ, Ga",{"$f":"MultiReplace(\nB11:B17,$D$6,$E$6)","v":"New Jersey, Georgia"}]
[null,"MS, MO",{"$f":"MultiReplace(\nB12:B18,$D$6,$E$6)","v":"MS, MO"}]

{"sheet":"XLOOKUP","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"Old","Replace with","Source Data Values","Result After Replacing "]
[null,"NJ","New Jersey","NJ",{"$f":"_xlfn.XLOOKUP($D6,$B$6:$B$10,$C$6:$C$10,$D6)","v":"New Jersey"}]
[null,"Ga","Georgia","NC",{"$f":"_xlfn.XLOOKUP($D7,$B$6:$B$10,$C$6:$C$10,$D7)","v":"NC"}]
[null,"CA","California","CA","California"]
[null,"HI","Hawaii","HI","Hawaii"]
[null,null,null,"MS","MS"]
[null,null,null,"Ga","Georgia"]
[null,null,null,"MO","MO"]

{"sheet":"Find and Select Tool","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"States of USA"]
[null,"NY, New Jersey"]
[null,"NC, New Jersey"]
[null,"GA, CA"]
[null,"HI, ID"]
[null,"MS, CA"]
[null,"New Jersey, Ga"]
[null,"MS, MO"]

{"sheet":"Substitute","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel find and replace multiple values"]
[]
[null,"Source Data values","Result After Replacing ","Old","Replace with"]
[null,"NY, NJ",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($B$6:$B$12, $D$6, $E$6), $D$7, $E$7),$D$8, $E$8), $D$9, $E$9)","v":"NY, New Jersey"},"NJ","New Jersey"]
[null,"NC, NJ",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($B$6:$B$12, $D$6, $E$6), $D$7, $E$7),$D$8, $E$8), $D$9, $E$9)","v":"NC, New Jersey"},"Ga","Georgia"]
[null,"GA, CA","GA, California","CA","California"]
[null,"HI, ID","Hawaii, ID","HI","Hawaii"]
[null,"MS, CA","MS, California"]
[null,"NJ, Ga","New Jersey, Georgia"]
[null,"MS, MO","MS, MO"]

{"sheet":"Replace","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Excel Find and Replace Multiple Values"]
[]
[null,"Source Data Values","Result After Replacing "]
[null,"2010-John-xgb",{"$f":"REPLACE(B6,1,4,10)","v":"10-John-xgb"}]
[null,"2010-Carlos-zxg",{"$f":"REPLACE(B7,1,4,10)","v":"10-Carlos-zxg"}]
[null,"2010-Ronaldo-xgb","10-Ronaldo-xgb"]
[null,"2010-Lia-zgb","10-Lia-zgb"]
[null,"2010-Iniesta-xww","10-Iniesta-xww"]
[null,"2010-Jake-rrt","10-Jake-rrt"]
[null,"2010-Leon-xfg","10-Leon-xfg"]