{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","TRIM","Find and Replace","REPLACE & LEN","SUBSTITUTE","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":"Data","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Salesman","Product ","Product Code"]
[null,"   Mark Hopper"," Laptop","   L-  0022-  HP"]
[null," Tim   Burnet","Mobile","M-  0125- SONY"]
[null,"Jimmy Cathway","  Speaker"," S- 0345-  JBL"]
[null,"  Harold   Finch","Calculator","  C- 1208- CASIO"]

{"sheet":"TRIM","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,1,9,3],[1,5,1,7]]}
[]
[null,"Using TRIM Function",null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product ","Product Code",null,"Salesman","Product ","Product Code"]
[null,"   Mark Hopper"," Laptop","   L-  0022-  HP",null,"   Mark Hopper"," Laptop","   L-  0022-  HP"]
[null," Tim   Burnet","Mobile","M-  0125- SONY",null," Tim   Burnet"," Mobile","M-  0125- SONY"]
[null,"Jimmy Cathway","  Speaker"," S- 0345-  JBL",null,"Jimmy  Cathway","  Speaker","  S- 0345-  JBL"]
[null,"  Harold   Finch","Calculator","  C- 1208- CASIO",null,"  Harold   Finch","  Calculator","  C- 1208- CASIO"]
[]
[null,"Leading Space Removed"]
[]
[null,"Salesman","Product ","Product Code"]
[null,{"$f":"TRIM(B5)","v":"Mark Hopper"},{"$f":"TRIM(C5)","v":"Laptop"},"L- 0022- HP"]
[null,{"$f":"TRIM(B6)","v":"Tim Burnet"},"Mobile","M- 0125- SONY"]
[null,"Jimmy Cathway","Speaker",{"$f":"TRIM(D7)","v":"S- 0345- JBL"}]
[null,"Harold Finch","Calculator","C- 1208- CASIO"]

{"sheet":"Find and Replace","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Utilizing Find and Replace Feature",null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Product Code",null,"Salesman","Product","Product Code"]
[null,"MarkHopper","Laptop","L-0022-HP",null,"   Mark Hopper"," Laptop","   L-  0022-  HP"]
[null,"TimBurnet","Mobile","M-0125-SONY",null," Tim   Burnet","  Mobile","M-  0125- SONY"]
[null,"JimmyCathway","Speaker","S-0345-JBL",null,"Jimmy  Cathway"," Speaker","  S- 0345-  JBL"]
[null,"HaroldFinch","Calculator","C-1208-CASIO",null,"  Harold   Finch","  Calculator","  C- 1208- CASIO"]

{"sheet":"REPLACE & LEN","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2],[1,4,1,5]]}
[]
[null,"Applying REPLACE and LEN Functions",null,null,"Practice Yourself"]
[]
[null,"Salesman","Product ",null,"Salesman","Product "]
[null,"   Mark Hopper"," Laptop",null,"   Mark Hopper"," Laptop"]
[null," Tim Burnet","Mobile",null," Tim Burnet"," Mobile"]
[null,"Jimmy Cathway","  Speaker",null,"Jimmy  Cathway","  Speaker"]
[null,"  Harold Finch","Calculator",null,"  Harold Finch","  Calculator"]
[]
[null,"Leading Space Removed"]
[]
[null,"Salesman","Product "]
[null,{"$f":"REPLACE(B5,1,LEN(B5)-LEN(TRIM(B5)),\"\")","v":"Mark Hopper"},{"$f":"REPLACE(C5,1,LEN(C5)-LEN(TRIM(C5)),\"\")","v":"Laptop"}]
[null,{"$f":"REPLACE(B6,1,LEN(B6)-LEN(TRIM(B6)),\"\")","v":"Tim Burnet"},"Mobile"]
[null,"Jimmy Cathway","Speaker"]
[null,"Harold Finch","Calculator"]
[null,null,{"$f":"REPLACE(C9,1,LEN(C9)-LEN(TRIM(C9)),\"\")","v":""}]

{"sheet":"SUBSTITUTE","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,1,9,3],[1,5,1,7]]}
[]
[null,"Inserting SUBSTITUTE Function",null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product ","Product Code",null,"Salesman","Product ","Product Code"]
[null,"   Mark Hopper"," Laptop","   L-  0022-  HP",null,"   Mark Hopper"," Laptop","   L-  0022-  HP"]
[null," Tim   Burnet","Mobile","M-  0125- SONY",null," Tim   Burnet"," Mobile","M-  0125- SONY"]
[null,"Jimmy Cathway","  Speaker"," S- 0345-  JBL",null,"Jimmy  Cathway","  Speaker","  S- 0345-  JBL"]
[null,"  Harold   Finch","Calculator","  C- 1208- CASIO",null,"  Harold   Finch","  Calculator","  C- 1208- CASIO"]
[]
[null,"Leading Space Removed"]
[]
[null,"Salesman","Product ","Product Code"]
[null,{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"MarkHopper"},{"$f":"SUBSTITUTE(C5,\" \",\"\")","v":"Laptop"},"L-0022-HP"]
[null,{"$f":"SUBSTITUTE(B6,\" \",\"\")","v":"TimBurnet"},{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"Mobile"},"M-0125-SONY"]
[null,"JimmyCathway","Speaker","S-0345-JBL"]
[null,"HaroldFinch","Calculator","C-1208-CASIO"]

{"sheet":"VBA","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Incorporating VBA",null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product ","Product Code",null,"Salesman","Product ","Product Code"]
[null,"Mark Hopper","Laptop","L-  0022-  HP",null,"Mark Hopper","  Laptop","L-  0022-  HP"]
[null,"Tim   Burnet","Mobile","M-  0125- SONY",null," Tim   Burnet","  Mobile","M-  0125- SONY"]
[null,"Jimmy Cathway","Speaker","S- 0345-  JBL",null,"Jimmy  Cathway","Speaker","  S- 0345-  JBL"]
[null,"Harold   Finch","Calculator","C- 1208- CASIO",null,"Harold   Finch"," Calculator","C- 1208- CASIO"]