{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Trim Function","SUBSTITUTE Function","Replace Function","Find and Replace ","Text to Column","VBA Macro Code"],"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset of Names"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane    ","Doe",{"$f":"B4&C4","v":"Jane    Doe"}]
[null,"Kit    ","Harington",{"$f":"B5&C5","v":"Kit    Harington"}]
[null,"Jane    ","Austin","Jane    Austin"]
[null,"Julia    ","Roberts","Julia    Roberts"]
[null,"Andrew    ","Eric","Andrew    Eric"]
[null,"Bob    ","Harly","Bob    Harly"]
[null,"Rocky    ","Montana","Rocky    Montana"]
[null,"Jay    ","Hope","Jay    Hope"]
[null,"Jony    ","Wilson","Jony    Wilson"]

{"sheet":"Trim Function","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using TRIM Function"]
[null,"First Name","Removed Trailing Spaces","Last Name","Full Name"]
[null,"Jane    ",{"$f":"TRIM(B4)","v":"Jane"},"Doe  ",{"$f":"C4&D4","v":"JaneDoe  "}]
[null,"Kit    ",{"$f":"TRIM(B5)","v":"Kit"},"Harington  ",{"$f":"C5&D5","v":"KitHarington  "}]
[null,"Jane    ","Jane","Austin  ","JaneAustin  "]
[null,"Julia    ","Julia","Roberts  ","JuliaRoberts  "]
[null,"Andrew    ","Andrew"," Eric  ","Andrew Eric  "]
[null,"Bob    ","Bob","Harly  ","BobHarly  "]
[null,"Rocky    ","Rocky","Montana  ","RockyMontana  "]
[null,"Jay    ","Jay","Hope   ","JayHope   "]
[null,"Jony    ","Jony","Wilson  ","JonyWilson  "]

{"sheet":"SUBSTITUTE Function","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUBSTITUTE Function"]
[null,"First Name","Removed Trailing Spaces","Last Name","Full Name"]
[null,"Jane    ",{"$f":"(SUBSTITUTE(B4,CHAR(32),\"\"))","v":"Jane"}," Doe  ",{"$f":"C4&D4","v":"Jane Doe  "}]
[null,"Kit    ",{"$f":"(SUBSTITUTE(B5,CHAR(32),\"\"))","v":"Kit"}," Harington  ",{"$f":"C5&D5","v":"Kit Harington  "}]
[null,"Jane    ","Jane"," Austin  ","Jane Austin  "]
[null,"Julia    ","Julia"," Roberts  ","Julia Roberts  "]
[null,"Andrew    ","Andrew"," Eric  ","Andrew Eric  "]
[null,"Bob    ","Bob"," Harly  ","Bob Harly  "]
[null,"Rocky    ","Rocky"," Montana  ","Rocky Montana  "]
[null,"Jay    ","Jay"," Hope   ","Jay Hope   "]
[null,"Jony    ","Jony"," Wilson  ","Jony Wilson  "]

{"sheet":"Replace Function","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using REPLACE Function"]
[null,"First Name","Extra Spaces","Removed Trailing Spaces","Last Name","Full Name"]
[null,"Jane    ",{"$f":"LEN(B4)-LEN(TRIM(B4))","v":4},{"$f":"REPLACE(B4,5,3,\"\")","v":"Jane "},"Doe",{"$f":" B4&E4","v":"Jane    Doe"}]
[null,"Kit    ",{"$f":"LEN(B5)-LEN(TRIM(B5))","v":4},{"$f":"REPLACE(B5,5,3,\"\")","v":"Kit "},"Harington",{"$f":" D5&E5","v":"Kit Harington"}]
[null,"Jane    ",4,"Jane ","Austin","Jane Austin"]
[null,"Julia    ",4,"Juli  ","Roberts","Juli  Roberts"]
[null,"Andrew    ",4,"Andr   ","Eric","Andr   Eric"]
[null,"Bob    ",4,"Bob ","Harly","Bob Harly"]
[null,"Rocky    ",4,"Rock  ","Montana","Rock  Montana"]
[null,"Jay    ",4,"Jay ","Hope","Jay Hope"]
[null,"Jony    ",4,"Jony ","Wilson","Jony Wilson"]

{"sheet":"Find and Replace ","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Find and Replace Feature"]
[null,"First Name","Extra Spaces","Last Name","Full Name"]
[null,"Jane ",{"$f":"LEN(B4)-LEN(TRIM(B4))","v":1},"Doe",{"$f":"B4&D4","v":"Jane Doe"}]
[null,"Kit ",{"$f":"LEN(B5)-LEN(TRIM(B5))","v":1},"Harington",{"$f":"B5&D5","v":"Kit Harington"}]
[null,"Jane ",1,"Austin",{"$f":"B6&D6","v":"Jane Austin"}]
[null,"Julia ",1,"Roberts",{"$f":"B7&D7","v":"Julia Roberts"}]
[null,"Andrew ",1,"Eric",{"$f":"B8&D8","v":"Andrew Eric"}]
[null,"Bob ",1,"Harly",{"$f":"B9&D9","v":"Bob Harly"}]
[null,"Rocky ",1,"Montana",{"$f":"B10&D10","v":"Rocky Montana"}]
[null,"Jay ",1,"Hope",{"$f":"B11&D11","v":"Jay Hope"}]
[null,"Jony ",1,"Wilson",{"$f":"B12&D12","v":"Jony Wilson"}]

{"sheet":"Text to Column","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Text to Column Feature"]
[null,"First Name","Spare Column ","Last Name","Full Name"]
[null,"Jane",null,"Doe",{"$f":"B4&D4","v":"JaneDoe"}]
[null,"Kit",null,"Harington",{"$f":"B5&D5","v":"KitHarington"}]
[null,"Jane",null,"Austin","JaneAustin"]
[null,"Julia",null,"Roberts","JuliaRoberts"]
[null,"Andrew",null,"Eric","AndrewEric"]
[null,"Bob",null,"Harly","BobHarly"]
[null,"Rocky",null,"Montana","RockyMontana"]
[null,"Jay",null,"Hope","JayHope"]
[null,"Jony",null,"Wilson","JonyWilson"]

{"sheet":"VBA Macro Code","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Macro Code"]
[null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"B4&C4","v":"JaneDoe"}]
[null,"Kit","Harington",{"$f":"B5&C5","v":"KitHarington"}]
[null,"Jane","Austin","JaneAustin"]
[null,"Julia","Roberts","JuliaRoberts"]
[null,"Andrew","Eric","AndrewEric"]
[null,"Bob","Harly","BobHarly"]
[null,"Rocky","Montana","RockyMontana"]
[null,"Jay","Hope","JayHope"]
[null,"Jony","Wilson","JonyWilson"]