{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Selected Cells","Wildcard","Line Break","Formatting","Cell Reference","Find&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":"Dataset","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"David","Monitor",10,200,2000]
[null,"Liz","Fridge",15,500,7500]
[null,"Smith","Fan",20,50,1000]
[null,"William","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"Liam","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]

{"sheet":"Selected Cells","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find and Replace in Selected Cells Only"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"David","Monitor",10,200,2000]
[null,"Liz","Fridge",15,500,7500]
[null,"Steve Smith","Fan",20,50,1000]
[null,"William","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"Liam","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]

{"sheet":"Wildcard","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Wildcard to Find and Replace"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"David","Monitor",10,200,2000]
[null,"Liz","Fridge",15,500,7500]
[null,"Smith","Fan",20,50,1000]
[null,"James","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"James","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]

{"sheet":"Line Break","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Removing Line Break in Excel"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"David","Monitor, LG27MP500",10,200,2000]
[null,"Liz","Fridge, RB36R8839SR/EU",15,500,7500]
[null,"Smith","Fan",20,50,1000]
[null,"William","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"Liam","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]

{"sheet":"Formatting","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Change Formatting Using Find and Replace Feature"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"David","Monitor",10,200,2000]
[null,"Liz","Fridge",15,500,7500]
[null,"Smith","Fan",20,50,1000]
[null,"William","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"Liam","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]

{"sheet":"Cell Reference","index":5,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find and Replace Cell Reference"]
[]
[null,"Sales Rep","Items","Unit Price","Sales",null,"Sales Rep","Sales"]
[null,"David","Monitor",200,2000,null,"Smith",{"$f":"VLOOKUP($G$5,$B$5:$E$15,4,TRUE)","v":2500}]
[null,"Liz","Fridge",500,7500,null,"Emma",{"$f":"VLOOKUP($G$6,$B$5:$E$15,4,TRUE)","v":2000}]
[null,"Smith","Fan",50,1000]
[null,"William","TV",500,6000]
[null,"Marry","AC",800,8000]
[null,"Olivia","Monitor",250,3750]
[null,"Emma","Fridge",650,6500]
[null,"Liam","Fan",80,800]
[null,"Elijah","Keyboard",80,2400]
[null,"Oliver","Speaker",50,1000]
[null,"Lucas","Microwave",250,2500]

{"sheet":"Find&Replace_VBA","index":6,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Find and Replace Using VBA"]
[]
[null,"Sales Rep","Items","Quantity","Unit Price","Sales"]
[null,"Steve","Monitor",10,200,2000]
[null,"Liz","Fridge",15,500,7500]
[null,"Smith","Fan",20,50,1000]
[null,"William","TV",12,500,6000]
[null,"Marry","AC",10,800,8000]
[null,"Olivia","Monitor",15,250,3750]
[null,"Emma","Fridge",10,650,6500]
[null,"Liam","Fan",10,80,800]
[null,"Elijah","Keyboard",30,80,2400]
[null,"Oliver","Speaker",20,50,1000]
[null,"Lucas","Microwave",10,250,2500]