{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Find & Select","REPLACE","SUBSTITUTE","Flash Fill","RIGHT and LEN","Excel 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":"Find & Select","index":0,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of Find & Select Command",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600,null,null,null,null,null,null,null,"Wilham","Cable",2600]
[null,"Simon","AC",8750,null,null,null,null,null,null,null,"Simon","AC",8750]
[null,"Frank","TV",7500,null,null,null,null,null,null,null,"Frank","TV",7500]
[null,"Nathan","Fridge",6900,null,null,null,null,null,null,null,"Nathan","Fridge",6900]

{"sheet":"REPLACE","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of REPLACE Function"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable","£2600",{"$f":"REPLACE(D5,1,1,\"\")","v":"2600"}]
[null,"Simon","AC","£8750",{"$f":"REPLACE(D6,1,1,\"\")","v":"8750"}]
[null,"Frank","TV","£7500","7500"]
[null,"Nathan","Fridge","£6900","6900"]

{"sheet":"SUBSTITUTE","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of SUBSTITUTE Function"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable","£2600",{"$f":"SUBSTITUTE(D5, \"£\", \"\")","v":"2600"}]
[null,"Simon","AC","£8750",{"$f":"SUBSTITUTE(D6, \"£\", \"\")","v":"8750"}]
[null,"Frank","TV","£7500","7500"]
[null,"Nathan","Fridge","£6900","6900"]

{"sheet":"Flash Fill","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Flash Fill Feature"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable","£2600",2600]
[null,"Simon","AC","£8750",8750]
[null,"Frank","TV","£7500",7500]
[null,"Nathan","Fridge","£6900",6900]

{"sheet":"RIGHT and LEN","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combination of RIGHT and LEN Functions"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable","£2600",{"$f":"RIGHT(D5,LEN(D5)-1)","v":"2600"}]
[null,"Simon","AC","£8750",{"$f":"RIGHT(D6,LEN(D6)-1)","v":"8750"}]
[null,"Frank","TV","£7500","7500"]
[null,"Nathan","Fridge","£6900","6900"]

{"sheet":"Excel VBA","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Excel VBA"]
[]
[null,"Salesman","Product","Net Sales"]
[null,"Wilham","#2600","#2600",{"$f":"ConvertSpecial(D5)","v":"2600"}]
[null,"Simon","#8750","#8750",{"$f":"ConvertSpecial(D6)","v":"8750"}]
[null,"Frank","#7500","#7500",{"$f":"ConvertSpecial(D7)","v":"7500"}]
[null,"Nathan","#6900","#6900",{"$f":"ConvertSpecial(D8)","v":"6900"}]