{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Data Set","TRIM","MID, FIND, LEN, TRIM","TRIM, CLEAN, SUBSTITUTE, CHAR","Find & Replace","Table1","Power Query","VBA & MACRO"],"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":"Data Set","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Extra Spaces in Excel"]
[]
[null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  "]

{"sheet":"TRIM","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of TRIM Function"]
[]
[null,"ID","Details","Updated Data"]
[null,"A-001","Jose, Age:    10, Grade:    4  ",{"$f":"TRIM(C5)","v":"Jose, Age: 10, Grade: 4"}]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ",{"$f":"TRIM(C6)","v":"Joe, Age: 12, Grade: 6"}]
[null,"A-003","Bret,          Age:    7, Grade:    2  ","Bret, Age: 7, Grade: 2"]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray, Age:13, Grade:7"]

{"sheet":"MID, FIND, LEN, TRIM","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of MID, FIND, LEN & TRIM Functions"]
[]
[null,"ID","Details","Updated Data"]
[null,"A-001","Jose,        Age:10,     Grade:4",{"$f":"MID(C5,FIND(MID(TRIM(C5),1,1),C5),LEN(C5))","v":"Jose,        Age:10,     Grade:4"}]
[null,"A-002","          Joe,          Age:12,     Grade:6  ",{"$f":"MID(C6,FIND(MID(TRIM(C6),1,1),C6),LEN(C6))","v":"Joe,          Age:12,     Grade:6  "}]
[null,"A-003","  Bret,        Age:7,       Grade:2  ","Bret,        Age:7,       Grade:2  "]
[null,"A-004","        Murray,  Age:13,     Grade:7  ","Murray,  Age:13,     Grade:7  "]

{"sheet":"TRIM, CLEAN, SUBSTITUTE, CHAR","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of TRIM, CLEAN, SUBSTITUTE and CHAR Functions"]
[]
[null,"ID","Details","Updated Data"]
[null,"A-001","Jose,  Age:   10, \n   Grade:   4",{"$f":"TRIM(CLEAN(SUBSTITUTE(C5,CHAR(160),\"\")))","v":"Jose, Age: 10, Grade: 4"}]
[null,"A-002",{"$f":"CHAR(7) &\" Joe,   Age:   12,   Grade:  6\"","v":"\u0007 Joe,   Age:   12,   Grade:  6"},{"$f":"TRIM(CLEAN(SUBSTITUTE(C6,CHAR(160),\"\")))","v":"Joe, Age: 12, Grade: 6"}]
[null,"A-003","      Bret,  \n  Age:   7,  Grade:   2","Bret, Age: 7, Grade: 2"]
[null,"A-004","    Murray,    Age:13,     Grade:7","Murray, Age:13, Grade:7"]

{"sheet":"Find & Replace","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Find & Replace Tool"]
[]
[null,"ID","Details"]
[null,"A-001","Jose,Age:10,Grade:4"]
[null,"A-002","Joe,Age:12,Grade:6"]
[null,"A-003","Bret,Age:7,Grade:2"]
[null,"A-004","Murray,Age:13,Grade:7"]

{"sheet":"Table1","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Details"]
["Jose,        Age:10,     Grade:4"]
["Joe,          Age:12,     Grade:6"]
["Bret,        Age:7,       Grade:2"]
["Murray,  Age:13,     Grade:7"]

{"sheet":"Power Query","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Power Query Appilication"]
[]
[null,"ID","Details"]
[null,"A-001","Jose,        Age:10,     Grade:4"]
[null,"A-002","          Joe,          Age:12,     Grade:6  "]
[null,"A-003","  Bret,        Age:7,       Grade:2  "]
[null,"A-004","        Murray,  Age:13,     Grade:7  "]

{"sheet":"VBA & MACRO","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA & MACRO"]
[]
[null,"ID","Details"]
[null,"A-001","Jose,        Age:10,     Grade:4"]
[null,"A-002","Joe,          Age:12,     Grade:6"]
[null,"A-003","Bret,        Age:7,       Grade:2"]
[null,"A-004","Murray,  Age:13,     Grade:7"]