{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Find and Replace Multiple Words","Nested SUBSTITUTE Function","Using XLOOKUP Function","IFNA & VLOOKUP Functions","Creating Custom LAMBDA Function","Using User-Defined Function","Applying VBA","Using REPLACE Function","Combining Functions","Find & Replace Single Word"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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 and Replace Multiple Words","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding and Replacing Multiple Words"]
[]
[null,"Source List",null,"Short Form","Country Name"]
[null,"Alabama, USA",null,"USA","United States"]
[null,"Rome, IT",null,"IT","Italy"]
[null,"Florida, USA",null,"SP","Spain"]
[null,"Madrid, SP"]
[null,"Virginia, USA"]
[null,"Barcelona, SP"]
[null,"Milan, IT"]

{"sheet":"Nested SUBSTITUTE Function","index":1,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Nested SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List","Result",null,"Short Form","Country Name",null,null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"Alabama, USA",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B5:B11,E5,F5),E6,F6),E7,F7)","v":"Alabama, United States"},null,"USA","United States",null,null,null,null,null,"Alabama, USA",null,null,"USA","United States"]
[null,"Rome, IT","Rome, Italy",null,"IT","Italy",null,null,null,null,null,"Rome, IT",null,null,"IT","Italy"]
[null,"Florida, USA","Florida, United States",null,"SP","Spain",null,null,null,null,null,"Florida, USA",null,null,"SP","Spain"]
[null,"Madrid, SP","Madrid, Spain",null,null,null,null,null,null,null,null,"Madrid, SP"]
[null,"Virginia, USA","Virginia, United States",null,null,null,null,null,null,null,null,"Virginia, USA"]
[null,"Barcelona, SP","Barcelona, Spain",null,null,null,null,null,null,null,null,"Barcelona, SP"]
[null,"Milan, IT","Milan, Italy",null,null,null,null,null,null,null,null,"Milan, IT"]

{"sheet":"Using XLOOKUP Function","index":2,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Using XLOOKUP Function",null,null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List","Result",null,"Short Form","Country Name",null,null,null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"USA",{"$f":"_xlfn.XLOOKUP(B5, $E$5:$E$7, $F$5:$F$7, B5)","v":"United States"},null,"USA","United States",null,null,null,null,null,null,"USA",null,null,"USA","United States"]
[null,"France",{"$f":"_xlfn.XLOOKUP(B6, $E$5:$E$7, $F$5:$F$7, B6)","v":"France"},null,"IT","Italy",null,null,null,null,null,null,"France",null,null,"IT","Italy"]
[null,"Poland","Poland",null,"SP","Spain",null,null,null,null,null,null,"Poland",null,null,"SP","Spain"]
[null,"SP","Spain",null,null,null,null,null,null,null,null,null,"SP"]
[null,"UK","UK",null,null,null,null,null,null,null,null,null,"UK"]
[null,"BD","BD",null,null,null,null,null,null,null,null,null,"BD"]
[null,"IT","Italy",null,null,null,null,null,null,null,null,null,"IT"]

{"sheet":"IFNA & VLOOKUP Functions","index":3,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Applying IFNA & VLOOKUP Functions",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List","Result",null,"Short Form","Country Name",null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"USA",{"$f":"_xlfn.IFNA(VLOOKUP(B5, $E$5:$F$7, 2, FALSE), B5)","v":"United States"},null,"USA","United States",null,null,null,null,"USA",null,null,"USA","United States"]
[null,"France",{"$f":"_xlfn.IFNA(VLOOKUP(B6, $E$5:$F$7, 2, FALSE), B6)","v":"France"},null,"IT","Italy",null,null,null,null,"France",null,null,"IT","Italy"]
[null,"Poland","Poland",null,"SP","Spain",null,null,null,null,"Poland",null,null,"SP","Spain"]
[null,"SP","Spain",null,null,null,null,null,null,null,"SP"]
[null,"UK","UK",null,null,null,null,null,null,null,"UK"]
[null,"BD","BD",null,null,null,null,null,null,null,"BD"]
[null,"IT","Italy",null,null,null,null,null,null,null,"IT"]

{"sheet":"Creating Custom LAMBDA Function","index":4,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Creating Custom LAMBDA Function",null,null,null,null,null,null,null,null,null,"Do It YouSelf"]
[]
[null,"Source List","Result",null,"Short Form","Country Name",null,null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"USA",{"$f":"MReplace(B5:B11,E5,F5)","v":"United States"},null,"USA","United States",null,null,null,null,null,"USA",null,null,"USA","United States"]
[null,"France","France",null,"IT","Italy",null,null,null,null,null,"France",null,null,"IT","Italy"]
[null,"Poland","Poland",null,"SP","Spain",null,null,null,null,null,"Poland",null,null,"SP","Spain"]
[null,"SP","Spain",null,null,null,null,null,null,null,null,"SP"]
[null,"UK","UK",null,null,null,null,null,null,null,null,"UK"]
[null,"BD","BD",null,null,null,null,null,null,null,null,"BD"]
[null,"IT","Italy",null,null,null,null,null,null,null,null,"IT"]

{"sheet":"Using User-Defined Function","index":5,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Using User-Defined Function",null,null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List","Result",null,"Short Form","Country Name",null,null,null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"USA",{"$f":"MultiWordReplace(B5:B11,E5:E7,F5:F7)","v":"United States"},null,"USA","United States",null,null,null,null,null,null,"USA",null,null,"USA","United States"]
[null,"France","France",null,"IT","Italy",null,null,null,null,null,null,"France",null,null,"IT","Italy"]
[null,"Poland","Poland",null,"SP","Spain",null,null,null,null,null,null,"Poland",null,null,"SP","Spain"]
[null,"SP","Spain",null,null,null,null,null,null,null,null,null,"SP"]
[null,"UK","UK",null,null,null,null,null,null,null,null,null,"UK"]
[null,"BD","BD",null,null,null,null,null,null,null,null,null,"BD"]
[null,"IT","Italy",null,null,null,null,null,null,null,null,null,"IT"]

{"sheet":"Applying VBA","index":6,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List",null,"Short Form","Country Name",null,null,null,null,null,"Source List",null,"Short Form","Country Name"]
[null,"Paris, France",null,"FR","France",null,null,null,null,null,"Paris, FR",null,"FR","France"]
[null,"Rome, Italy",null,"IT","Italy",null,null,null,null,null,"Rome, IT",null,"IT","Italy"]
[null,"Cannes, France",null,"SP","Spain",null,null,null,null,null,"Cannes, FR",null,"SP","Spain"]
[null,"Madrid, Spain",null,null,null,null,null,null,null,null,"Madrid, SP"]
[null,"Toledo, Spain",null,null,null,null,null,null,null,null,"Toledo, SP"]
[null,"Milan, Italy",null,null,null,null,null,null,null,null,"Milan, IT"]
[null,"Barcelona, Spain",null,null,null,null,null,null,null,null,"Barcelona, SP"]

{"sheet":"Using REPLACE Function","index":7,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,12,2,16]]}
[]
[null,"Using REPLACE Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[null,"Source List","Result",null,"Short Form","Country Name"]
[null,"US",{"$f":"REPLACE(B5:B9,1,2,F5:F9)","v":"United States"},null,"US","United States",null,null,null,null,null,null,"Source List","Result",null,"Short Form","Country Name"]
[null,"IT","Italy",null,"IT","Italy",null,null,null,null,null,null,"US",null,null,"US","United States"]
[null,"SP","Spain",null,"SP","Spain",null,null,null,null,null,null,"BD",null,null,"IT","Italy"]
[null,"FR","France",null,"FR","France",null,null,null,null,null,null,"UK",null,null,"SP","Spain"]
[null,"UK","United Kingdom",null,"UK","United Kingdom",null,null,null,null,null,null,"SP",null,null,"BD","Bangladesh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IT",null,null,"UK","United Kingdom"]

{"sheet":"Combining Functions","index":8,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Combining IF, REPLACE & LEN Functions",null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List","Result",null,null,null,null,"Source List","Result"]
[null,"US",{"$f":"IF(LEN(B5)=2,REPLACE(B5,1,2,IF(B5=\"US\",\"United States\",IF(B5=\"SP\",\"Spain\",IF(B5=\"UK\",\"United Kingdom\")))),B5)","v":"United States"},null,null,null,null,"US"]
[null,"France",{"$f":"IF(LEN(B6)=2,REPLACE(B6,1,2,IF(B6=\"US\",\"United States\",IF(B6=\"SP\",\"Spain\",IF(B6=\"UK\",\"United Kingdom\")))),B6)","v":"France"},null,null,null,null,"France"]
[null,"UK","United Kingdom",null,null,null,null,"UK"]
[null,"SP","Spain",null,null,null,null,"SP"]
[null,"Italy","Italy",null,null,null,null,"Italy"]

{"sheet":"Find & Replace Single Word","index":9,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Finding & Replacing Single Word Multiple Times",null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Source List",null,null,null,null,null,"Source List"]
[null,"Alabama, United States",null,null,null,null,null,"Alabama, USA"]
[null,"Florida, United States",null,null,null,null,null,"Florida, USA"]
[null,"Virginia, United States",null,null,null,null,null,"Virginia, USA"]
[null,"Maryland, United States",null,null,null,null,null,"Maryland, USA"]