{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TRIM","Find And Replace","SUBSTITUTE","TRIM,LEFT,LEN","TRIM,CLEAN,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":"TRIM","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Trim Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name","Result",null,null,null,null,null,"Office ID","Name","Result"]
[null,"HL236744","Alfred    Molina",{"$f":"TRIM(C5)","v":"Alfred Molina"},null,null,null,null,null,"HL236744","Alfred    Molina"]
[null,"HL456723","     Tim Roth",{"$f":"TRIM(C6)","v":"Tim Roth"},null,null,null,null,null,"HL456723","     Tim Roth"]
[null,"HL671237","Robin   Willium","Robin Willium",null,null,null,null,null,"HL671237","Robin   Willium"]
[null,"HL914567","Jonathan Nolan","Jonathan Nolan",null,null,null,null,null,"HL914567","Jonathan Nolan"]
[null,"HL126173","  Michael   Caine  ","Michael Caine",null,null,null,null,null,"HL126173","  Michael   Caine  "]
[null,"HL235137","   Norman   Bates","Norman Bates",null,null,null,null,null,"HL235137","   Norman   Bates"]

{"sheet":"Find And Replace","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[8,7,8,8],[1,9,1,10]]}
[]
[null,"Using Find And Replace Tool",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name",null,null,null,null,null,null,"Office ID","Name"]
[null,"HL236744","Alfred   Molina",null,null,null,null,null,null,"HL236744","Alfred   Molina"]
[null,"HL456723","Tim Roth  ",null,null,null,null,null,null,"HL456723","Tim Roth  "]
[null,"HL671237","  Robin Willium",null,null,null,null,null,null,"HL671237","  Robin Willium"]
[null,"HL914567","Jonathan   Nolan",null,null,null,null,null,null,"HL914567","Jonathan   Nolan"]
[null,"HL126173","  Michael Caine",null,null,null,null,null,null,"HL126173","  Michael Caine"]
[null,"HL235137","Norman   Bates",null,null,null,null,null,null,"HL235137","Norman   Bates"]

{"sheet":"SUBSTITUTE","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name","Result",null,null,null,null,null,"Office ID","Name","Result"]
[null,"HL236 744","Alfred Molina",{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"HL236744"},null,null,null,null,null,"HL236 744","Alfred Molina"]
[null,"HL45 6723","Tim Roth",{"$f":"SUBSTITUTE(B6,\" \",\"\")","v":"HL456723"},null,null,null,null,null,"HL45 6723","Tim Roth"]
[null,"HL67123 7","Robin Willium","HL671237",null,null,null,null,null,"HL67123 7","Robin Willium"]
[null,"HL 914567","Jonathan Nolan","HL914567",null,null,null,null,null,"HL 914567","Jonathan Nolan"]
[null,"HL1261 73","Michael Caine","HL126173",null,null,null,null,null,"HL1261 73","Michael Caine"]
[null,"HL2 35137","Norman Bates","HL235137",null,null,null,null,null,"HL2 35137","Norman Bates"]

{"sheet":"TRIM,LEFT,LEN","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of TRIM,LEFT,LEN Functions",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name","Result",null,null,null,null,null,"Office ID","Name","Result"]
[null,"HL236744","Alfred    Molina   ",{"$f":"TRIM(LEFT(C5,LEN(C5)-1))&\"\"","v":"Alfred Molina"},null,null,null,null,null,"HL236744","Alfred    Molina"]
[null,"HL456723","     Tim Roth ",{"$f":"TRIM(LEFT(C6,LEN(C6)-1))&\"\"","v":"Tim Roth"},null,null,null,null,null,"HL456723","     Tim Roth"]
[null,"HL671237","Robin   Willium ","Robin Willium",null,null,null,null,null,"HL671237","Robin   Willium"]
[null,"HL914567","Jonathan Nolan ","Jonathan Nolan",null,null,null,null,null,"HL914567","Jonathan Nolan"]
[null,"HL126173","  Michael   Caine  ","Michael Caine",null,null,null,null,null,"HL126173","  Michael   Caine  "]
[null,"HL235137","   Norman   Bates ","Norman Bates",null,null,null,null,null,"HL235137","   Norman   Bates"]

{"sheet":"TRIM,CLEAN,SUBSTITUTE","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using TRIM,CLEAN,SUBSTITUTE Functions",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name","Result",null,null,null,null,null,"Office ID","Name","Result"]
[null,"HL236 744","Alfred Molina",{"$f":"TRIM(CLEAN(SUBSTITUTE(B5,\" \",\"\")))","v":"HL236744"},null,null,null,null,null,"HL236 744","Alfred Molina"]
[null,"HL45 6723","Tim Roth",{"$f":"TRIM(CLEAN(SUBSTITUTE(B6,\" \",\"\")))","v":"HL456723"},null,null,null,null,null,"HL45 6723","Tim Roth"]
[null,"HL67123 7","Robin Willium","HL671237",null,null,null,null,null,"HL67123 7","Robin Willium"]
[null,"HL 914567","Jonathan Nolan","HL914567",null,null,null,null,null,"HL 914567","Jonathan Nolan"]
[null,"HL1261 73","Michael Caine","HL126173",null,null,null,null,null,"HL1261 73","Michael Caine"]
[null,"HL2 35137","Norman Bates","HL235137",null,null,null,null,null,"HL2 35137","Norman Bates"]

{"sheet":"VBA","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Office ID","Name",null,null,null,null,null,null,"Office ID","Name"]
[null,"HL236744","Alfred Molina",null,null,null,null,null,null,"HL236744"," Alfred Molina"]
[null,"HL456723","Tim Roth",null,null,null,null,null,null,"HL456723","       Tim Roth"]
[null,"HL671237","Robin Willium",null,null,null,null,null,null,"HL671237","  Robin Willium "]
[null,"HL914567","Jonathan Nolan",null,null,null,null,null,null,"HL914567","  Jonathan Nolan"]
[null,"HL126173","Michael Caine",null,null,null,null,null,null,"HL126173"," Michael Caine  "]
[null,"HL235137","Norman Bates",null,null,null,null,null,null,"HL235137","  Norman Bates "]