{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","TRIM","MID, FIND, LEN, TRIM","TRIM, CLEAN, SUBSTITUTE, CHAR","Find & Replace","Flash Fill","Power Query","Power Query Table","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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"List of Student Information"]
[]
[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  "]
[null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"TRIM","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Using TRIM Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Ouput",null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ",{"$f":"TRIM(C5)","v":"Jose, Age: 10, Grade: 4"},null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ",{"$f":"TRIM(C6)","v":"Joe, Age: 12, Grade: 6"},null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  ","Bret, Age: 7, Grade: 2",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray, Age:13, Grade:7",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ","James, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ","Marick, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  ","Betty, Age: 13, Grade: 7",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ","Michelle, Age:14, Grade:8",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ","Julian, Age: 6, Grade: 1",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ","Max, Age:15, Grade:9",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"MID, FIND, LEN, TRIM","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Combining MID, FIND, LEN & TRIM Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Output",null,null,null,null,null,null,null,"ID","Details"]
[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,null,null,null,null,null,null,"A-001","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,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","  Bret,        Age:7,       Grade:2  ","Bret,        Age:7,       Grade:2  ",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","        Murray,  Age:13,     Grade:7  ","Murray,  Age:13,     Grade:7  ",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James,        Age:12,     Grade:6","James,        Age:12,     Grade:6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","          Marick,          Age:12,     Grade:6  ","Marick,          Age:12,     Grade:6  ",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007","  Betty,        Age:13,       Grade:7  ","Betty,        Age:13,       Grade:7  ",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","        Michelle,  Age:14,     Grade:7  ","Michelle,  Age:14,     Grade:7  ",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","  Julian,        Age:6,       Grade:1  ","Julian,        Age:6,       Grade:1  ",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","        Max,  Age:15,     Grade:9  ","Max,  Age:15,     Grade:9  ",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"TRIM, CLEAN, SUBSTITUTE, CHAR","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Implementing TRIM, CLEAN, SUBSTITUTE and CHAR Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Output",null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ",{"$f":"TRIM(CLEAN(SUBSTITUTE(C5,CHAR(160),\"\")))","v":"Jose, Age: 10, Grade: 4"},null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ",{"$f":"TRIM(CLEAN(SUBSTITUTE(C6,CHAR(160),\"\")))","v":"Joe, Age: 12, Grade: 6"},null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          \nAge:    7, Grade:    2  ","Bret, Age: 7, Grade: 2",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray, Age:13, Grade:7",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ","James, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ","Marick, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          \nAge:    13, Grade:    7  ","Betty, Age: 13, Grade: 7",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ","Michelle, Age:14, Grade:8",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ","Julian, Age: 6, Grade: 1",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ","Max, Age:15, Grade:9",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"Find & Replace","index":4,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Employing Find & Replace Command",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Output",null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ","Jose,Age:10,Grade:4",null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ","Joe,Age:12,Grade:6",null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  ","Bret,Age:7,Grade:2",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray,Age:13,Grade:7",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ","James,Age:12,Grade:6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ","Marick,Age:12,Grade:6",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  ","Betty,Age:13,Grade:7",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ","Michelle,Age:14,Grade:8",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ","Julian,Age:6,Grade:1",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ","Max,Age:15,Grade:9",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"Flash Fill","index":5,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Utilizing Flash Fill",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Output",null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ","Jose, Age: 10, Grade: 4",null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ","Joe, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  ","Bret, Age: 7, Grade: 2",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray, Age: 13,  Grade: 7",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ","James, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ","Marick, Age: 12, Grade: 6",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  ","Betty, Age: 13, Grade: 7",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ","Michelle, Age: 14, Grade: 8",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ","Julian, Age: 6, Grade: 1",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ","Max, Age: 15, Grade: 9",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"Power Query","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using Power Query",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details",null,null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ",null,null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ",null,null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  ",null,null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ",null,null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ",null,null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ",null,null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  ",null,null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ",null,null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ",null,null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ",null,null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]

{"sheet":"Power Query Table","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query"]
[]
[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"]
[null,"A-005","James, Age:    12, Grade:   6"]
[null,"A-006","Marick,    Age:    12, Grade:    6"]
[null,"A-007","Betty,          Age:    13, Grade:    7"]
[null,"A-008","Michelle,    Age:14,      Grade:8"]
[null,"A-009","Julian,          Age:    6, Grade:    1"]
[null,"A-010","Max,    Age:15,      Grade:9"]

{"sheet":"VBA Code","index":8,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"ID","Details","Output",null,null,null,null,null,null,null,"ID","Details"]
[null,"A-001","Jose, Age:    10, Grade:    4  ","Jose, Age:    10, Grade:    4",null,null,null,null,null,null,null,"A-001","Jose, Age:    10, Grade:    4  "]
[null,"A-002","     Joe,    Age:    12, Grade:    6  ","Joe,    Age:    12, Grade:    6",null,null,null,null,null,null,null,"A-002","     Joe,    Age:    12, Grade:    6  "]
[null,"A-003","Bret,          Age:    7, Grade:    2  ","Bret,          Age:    7, Grade:    2",null,null,null,null,null,null,null,"A-003","Bret,          Age:    7, Grade:    2  "]
[null,"A-004","Murray,    Age:13,      Grade:7  ","Murray,    Age:13,      Grade:7",null,null,null,null,null,null,null,"A-004","Murray,    Age:13,      Grade:7  "]
[null,"A-005","James, Age:    12, Grade:   6  ","James, Age:    12, Grade:   6",null,null,null,null,null,null,null,"A-005","James, Age:    12, Grade:   6  "]
[null,"A-006","     Marick,    Age:    12, Grade:    6  ","Marick,    Age:    12, Grade:    6",null,null,null,null,null,null,null,"A-006","     Marick,    Age:    12, Grade:    6  "]
[null,"A-007"," Betty,          Age:    13, Grade:    7  ","Betty,          Age:    13, Grade:    7",null,null,null,null,null,null,null,"A-007"," Betty,          Age:    13, Grade:    7  "]
[null,"A-008","Michelle,    Age:14,      Grade:8  ","Michelle,    Age:14,      Grade:8",null,null,null,null,null,null,null,"A-008","Michelle,    Age:14,      Grade:8  "]
[null,"A-009","Julian,          Age:    6, Grade:    1  ","Julian,          Age:    6, Grade:    1",null,null,null,null,null,null,null,"A-009","Julian,          Age:    6, Grade:    1  "]
[null,"A-010","Max,    Age:15,      Grade:9  ","Max,    Age:15,      Grade:9",null,null,null,null,null,null,null,"A-010","Max,    Age:15,      Grade:9  "]