{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["main","Find&Replace","substitute","Xlookup","Vlookup","replace","replaceif","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Find and Replace Multiple Words at Once in Excel"]
[]
[null,"Office#","Office Name","Office Name Full"]
[null,1,"AL"]
[null,2,"California"]
[null,3,"Delaware"]
[null,4,"IL"]
[null,5,"Texas"]
[null,6,"MS"]

{"sheet":"Find&Replace","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Find and Replace Command",null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name",null,null,null,"Office#","Office Name"]
[null,1,"Alabama",null,null,null,1,"AL"]
[null,2,"California",null,null,null,2,"California"]
[null,3,"Delaware",null,null,null,3,"Delaware"]
[null,4,"Illinois",null,null,null,4,"Illinois"]
[null,5,"Alabama",null,null,null,5,"AL"]
[null,6,"Mississippi",null,null,null,6,"Mississippi"]

{"sheet":"substitute","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,10],[1,1,1,3]]}
[]
[null,"Using Nested SUBSTITUTE Function",null,null,null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,null,null,null,"Office#","Office Name"]
[null,1,"AL",{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C$5:$C$10,\"AL\",\"Alabama\"),\"IL\",\"Illinois\"),\"MS\",\"Mississippi\")","v":"Alabama"},null,null,null,null,1,"AL"]
[null,2,"California","California",null,null,null,null,2,"California"]
[null,3,"Delaware","Delaware",null,null,null,null,3,"Delaware"]
[null,4,"IL","Illinois",null,null,null,null,4,"IL"]
[null,5,"Texas","Texas",null,null,null,null,5,"Texas"]
[null,6,"MS","Mississippi",null,null,null,null,6,"MS"]

{"sheet":"Xlookup","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,6]]}
[]
[null,"Using XLOOKUP Function",null,null,null,null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,"Words","Replace",null,null,"Office#","Office Name",null,null,"Words","Replace"]
[null,1,"AL",{"$f":"_xlfn.XLOOKUP(C5,$F$5:$F$9,$G$5:$G$9,C5)","v":{"$error":"#NAME?"}},null,"AL","Alabama",null,null,1,"AL",null,null,"AL","Alabama"]
[null,2,"California",{"$error":"#NAME?"},null,"IL","Illinois",null,null,2,"California",null,null,"IL","Illinois"]
[null,3,"Delaware",{"$error":"#NAME?"},null,"MS","Mississippi",null,null,3,"Delaware",null,null,"MS","Mississippi"]
[null,4,"IL",{"$error":"#NAME?"},null,null,null,null,null,4,"IL"]
[null,5,"Texas",{"$error":"#NAME?"},null,null,null,null,null,5,"Texas"]
[null,6,"MS",{"$error":"#NAME?"},null,null,null,null,null,6,"MS"]

{"sheet":"Vlookup","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,10],[1,1,1,6]]}
[]
[null,"Using the VLOOKUP Function",null,null,null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,"Words","Replace",null,"Office#","Office Name",null,null,"Words","Replace"]
[null,1,"AL",{"$f":"IFERROR(VLOOKUP(C5,$F$5:$G$7,2,FALSE),C5)","v":"Alabama"},null,"AL","Alabama",null,1,"AL",null,null,"AL","Alabama"]
[null,2,"California",{"$f":"IFERROR(VLOOKUP(C6,$F$5:$G$7,2,FALSE),C6)","v":"California"},null,"IL","Illinois",null,2,"California",null,null,"IL","Illinois"]
[null,3,"Delaware","Delaware",null,"MS","Mississippi",null,3,"Delaware",null,null,"MS","Mississippi"]
[null,4,"IL","Illinois",null,null,null,null,4,"IL"]
[null,5,"Texas","Texas",null,null,null,null,5,"Texas"]
[null,6,"MS","Mississippi",null,null,null,null,6,"MS"]

{"sheet":"replace","index":5,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using the REPLACE Function",null,null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,"Replace",null,"Office#","Office Name","Office Name Full",null,"Replace"]
[null,1,"AL",{"$f":"REPLACE($C$5:$C$8,1,2,$F$5:$F$8)","v":"Alabama"},null,"Alabama",null,1,"AL",null,null,"Alabama"]
[null,2,"IL","Illinois",null,"Illinois",null,2,"IL",null,null,"Illinois"]
[null,3,"MS","Mississippi",null,"Mississippi",null,3,"MS",null,null,"Mississippi"]
[null,4,"TX","Texas",null,"Texas",null,4,"TX",null,null,"Texas"]

{"sheet":"replaceif","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,5,1,7],[1,1,1,3]]}
[]
[null,"Using IF, REPLACE, LEN Functions",null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,"Office#","Office Name","Office Name Full"]
[null,1,"AL",{"$f":"IF(LEN(C5)=2,REPLACE(C5,1,2,IF(C5=\"AL\",\"Alabama\",IF(C5=\"IL\",\"Illinois\",IF(C5=\"MS\",\"Missisippi\")))),C5)","v":"Alabama"},null,1,"AL"]
[null,2,"California",{"$f":"IF(LEN(C6)=2,REPLACE(C6,1,2,IF(C6=\"AL\",\"Alabama\",IF(C6=\"IL\",\"Illinois\",IF(C6=\"MS\",\"Missisippi\")))),C6)","v":"California"},null,2,"California"]
[null,3,"Delaware","Delaware",null,3,"Delaware"]
[null,4,"IL","Illinois",null,4,"IL"]
[null,5,"Texas","Texas",null,5,"Texas"]
[null,6,"MS","Missisippi",null,6,"MS"]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,6]]}
[]
[null,"Using a Custom VBA Function",null,null,null,null,null,null,null,"Practice"]
[]
[null,"Office#","Office Name","Office Name Full",null,"Words","Replace",null,null,"Office#","Office Name",null,null,"Words","Replace"]
[null,1,"AL",{"$f":"ReplaceWords(C5,$F$5:$F$7,$G$5:$G$7)","v":"Alabama"},null,"AL","Alabama",null,null,1,"Alabama",null,null,"AL","Alabama"]
[null,2,"California","California",null,"IL","Illinois",null,null,2,"California",null,null,"IL","Illinois"]
[null,3,"Delaware","Delaware",null,"MS","Mississippi",null,null,3,"Delaware",null,null,"MS","Mississippi"]
[null,4,"IL","Illinois",null,null,null,null,null,4,"Illinois"]
[null,5,"Texas","Texas",null,null,null,null,null,5,"Texas"]
[null,6,"MS","Mississippi",null,null,null,null,null,6,"Mississippi"]