{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Trim Formula","Substitute function","Trim&Substitute","Mid Function","VBA","SpaceBetweenNumbers"],"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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee","ID Number"]
[null,"Emily     John",10001]
[null,"      Adam Smith",10002]
[null,"Thomas Shelly  ",10003]
[null,"         William  Ray",10004]
[null,"Alex Carry",10005]

{"sheet":"Trim Formula","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,11]]}
[]
[null,"Use of TRIM Formula",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number","TRIM",null,null,null,null,null,null,"Employee","ID Number"]
[null,"Emily     John",10001,{"$f":"TRIM(B5)","v":"Emily John"},null,null,null,null,null,null,"Emily     John",10001]
[null,"      Adam Smith",10002,{"$f":"TRIM(B6)","v":"Adam Smith"},null,null,null,null,null,null,"      Adam Smith",10002]
[null,"Thomas Shelly  ",10003,"Thomas Shelly",null,null,null,null,null,null,"Thomas Shelly  ",10003]
[null,"         William  Ray",10004,"William Ray",null,null,null,null,null,null,"         William  Ray",10004]
[null,"Alex Carry",10005,"Alex Carry",null,null,null,null,null,null,"Alex Carry",10005]

{"sheet":"Substitute function","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,11]]}
[]
[null,"Use of SUBSTITUTE Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number","Helper Column",null,null,null,null,null,null,"Employee","ID Number"]
[null,"Emily     John",10001,{"$f":"SUBSTITUTE(B5,\" \",\"\")","v":"EmilyJohn"},null,null,null,null,null,null,"Emily     John",10001]
[null,"      Adam Smith",10002,{"$f":"SUBSTITUTE(B6,\" \",\"\")","v":"AdamSmith"},null,null,null,null,null,null,"      Adam Smith",10002]
[null,"Thomas Shelly  ",10003,"ThomasShelly",null,null,null,null,null,null,"Thomas Shelly  ",10003]
[null,"         William  Ray",10004,"WilliamRay",null,null,null,null,null,null,"         William  Ray",10004]
[null,"Alex Carry",10005,"AlexCarry",null,null,null,null,null,null,"Alex Carry",10005]

{"sheet":"Trim&Substitute","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,9]]}
[]
[null,"Use of SUBSTITUTE & TRIM Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number","Helper Column",null,null,null,null,"Employee","ID Number"]
[null,"Emily     John",10001,{"$f":"TRIM(SUBSTITUTE(B5,CHAR(160),CHAR(32)))","v":"Emily John"},null,null,null,null,"Emily     John",10001]
[null,"      Adam Smith",10002,{"$f":"TRIM(SUBSTITUTE(B6,CHAR(160),CHAR(32)))","v":"Adam Smith"},null,null,null,null,"      Adam Smith",10002]
[null,"Thomas Shelly  ",10003,"Thomas Shelly",null,null,null,null,"Thomas Shelly  ",10003]
[null,"         William  Ray",10004,"William Ray",null,null,null,null,"         William  Ray",10004]
[null,"Alex Carry",10005,"Alex Carry",null,null,null,null,"Alex Carry",10005]

{"sheet":"Mid Function","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,10]]}
[]
[null,"Use of MID Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number","Helper Column",null,null,null,null,null,"Employee","ID Number"]
[null,"Emily     John",10001,{"$f":"MID(B5,FIND(MID(TRIM(B5),1,1),B5),LEN(B5))","v":"Emily     John"},null,null,null,null,null,"Emily     John",10001]
[null,"      Adam Smith",10002,{"$f":"MID(B6,FIND(MID(TRIM(B6),1,1),B6),LEN(B6))","v":"Adam Smith"},null,null,null,null,null,"      Adam Smith",10002]
[null,"Thomas Shelly  ",10003,"Thomas Shelly  ",null,null,null,null,null,"Thomas Shelly  ",10003]
[null,"         William  Ray",10004,"William  Ray",null,null,null,null,null,"         William  Ray",10004]
[null,"Alex Carry",10005,"Alex Carry",null,null,null,null,null,"Alex Carry",10005]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"With VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number",null,null,null,null,null,null,"Employee","ID Number"]
[null,"Emily     John",10001,null,null,null,null,null,null,"Emily     John",10001]
[null,"Adam Smith",10002,null,null,null,null,null,null,"      Adam Smith",10002]
[null,"Thomas Shelly",10003,null,null,null,null,null,null,"Thomas Shelly  ",10003]
[null,"William  Ray",10004,null,null,null,null,null,null,"         William  Ray",10004]
[null,"Alex Carry",10005,null,null,null,null,null,null,"Alex Carry",10005]

{"sheet":"SpaceBetweenNumbers","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,10]]}
[]
[null,"Space Between Numbers",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","ID Number","Helper Column",null,null,null,null,null,"Employee","ID Number"]
[null,"Emily John",10001,{"$f":"SUBSTITUTE(C5,\" \",\"\")","v":"10001"},null,null,null,null,null,"Emily John","10  001"]
[null,"Adam Smith",10002,{"$f":"SUBSTITUTE(C6,\" \",\"\")","v":"10002"},null,null,null,null,null,"Adam Smith","100  02"]
[null,"Thomas Shelly",10003,"10003",null,null,null,null,null,"Thomas Shelly","10    003"]
[null,"William Ray",10004,"10004",null,null,null,null,null,"William Ray","1 0 004"]
[null,"Alex Carry",10005,"10005",null,null,null,null,null,"Alex Carry","1  0005"]