{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TRIM","SUBSTITUTE","Find and Replace","Power Query","Table4 (2)","VBA Code"],"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":"TRIM","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[null,"ID No","Name","Salary",null,"Name Using TRIM Function"]
[null,101,"  Adam  Smith ","12 80",null,{"$f":"TRIM(C4)","v":"Adam Smith"}]
[null,102,"Tom    Belar","11 20",null,{"$f":"TRIM(C5)","v":"Tom Belar"}]
[null,103,"   Ruth Gill","10 50",null,"Ruth Gill"]
[null,104,"Andrew   Louis","20 30",null,"Andrew Louis"]
[null,105,"  Lilly   Scott","10 40",null,"Lilly Scott"]
[null,106,"Sara    Harris","8 90",null,"Sara Harris"]
[null,107,"Joe    Neslon  ","12 00",null,"Joe Neslon"]
[null,108,"   Rick  Potter","89 0",null,"Rick Potter"]
[null,109," Ruby  Lee","13 56",null,"Ruby Lee"]
[null,110,"  Liana Cox ","14 78",null,"Liana Cox"]

{"sheet":"SUBSTITUTE","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[null,"ID No","Name","Salary",null,"Salary Using SUBSTITUTE Function"]
[null,101,"  Adam  Smith ","12 80",null,{"$f":"SUBSTITUTE(D4,\" \",\"\")","v":"1280"}]
[null,102,"Tom    Belar","11 20",null,{"$f":"SUBSTITUTE(D5,\" \",\"\")","v":"1120"}]
[null,103,"   Ruth Gill","10 50",null,"1050"]
[null,104,"Andrew   Louis","20 30",null,"2030"]
[null,105,"  Lilly   Scott","10 40",null,"1040"]
[null,106,"Sara    Harris","8 90",null,"890"]
[null,107,"Joe    Neslon  ","12 00",null,"1200"]
[null,108,"   Rick  Potter","89 0",null,"890"]
[null,109," Ruby  Lee","13 56",null,"1356"]
[null,110,"  Liana Cox ","14 78",null,"1478"]

{"sheet":"Find and Replace","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[null,"ID No","Name","Salary"]
[null,101,"  Adam  Smith ",1280]
[null,102,"Tom    Belar",1120]
[null,103,"   Ruth Gill",1050]
[null,104,"Andrew   Louis",2030]
[null,105,"  Lilly   Scott",1040]
[null,106,"Sara    Harris",890]
[null,107,"Joe    Neslon  ",1200]
[null,108,"   Rick  Potter",890]
[null,109," Ruby  Lee",1356]
[null,110,"  Liana Cox ",1478]

{"sheet":"Power Query","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[null,"ID No","Name","Salary"]
[null,101,"  Adam  Smith ","12 80"]
[null,102,"Tom    Belar","11 20"]
[null,103,"   Ruth Gill","10 50"]
[null,104,"Andrew   Louis","20 30"]
[null,105,"  Lilly   Scott","10 40"]
[null,106,"Sara    Harris","8 90"]
[null,107,"Joe    Neslon  ","12 00"]
[null,108,"   Rick  Potter","89 0"]
[null,109," Ruby  Lee","13 56"]
[null,110,"  Liana Cox ","14 78"]

{"sheet":"Table4 (2)","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name"]
[null,"Adam  Smith"]
[null,"Tom    Belar"]
[null,"Ruth Gill"]
[null,"Andrew   Louis"]
[null,"Lilly   Scott"]
[null,"Sara    Harris"]
[null,"Joe    Neslon"]
[null,"Rick  Potter"]
[null,"Ruby  Lee"]
[null,"Liana Cox"]

{"sheet":"VBA Code","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee List"]
[null,"ID No","Name","Salary"]
[null,101,"Adam  Smith","12 80"]
[null,102,"Tom    Belar","11 20"]
[null,103,"Ruth Gill","10 50"]
[null,104,"Andrew   Louis","20 30"]
[null,105,"Lilly   Scott","10 40"]
[null,106,"Sara    Harris","8 90"]
[null,107,"Joe    Neslon","12 00"]
[null,108,"Rick  Potter","89 0"]
[null,109,"Ruby  Lee","13 56"]
[null,110,"Liana Cox","14 78"]