{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Sheet2","Trim Function","SUBSTITUTE Function","REPLACE Function","Find and Replace ","Text to Column","VBA Macro Code","for Numbers"],"not_rendered":{"charts":0,"images":1,"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Jane    ","Doe",{"$f":"B5&C5","v":"Jane    Doe"}]
[null,"Kit    ","Harington",{"$f":"B6&C6","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":"Sheet2","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,6],[1,1,1,6]]}
[]
[null,"Remove Trailing Spaces in Excel"]
[]
[null,"Dataset Overview",null,null,null,"Method Overview"]
[]
[null,"First Name","Last Name","Full Name",null,"Method","Formula/Feature Used"]
[null,"Jane    ","Doe",{"$f":"B7&C7","v":"Jane    Doe"},null,1,"=TRIM(B5)"]
[null,"Kit    ","Harington",{"$f":"B8&C8","v":"Kit    Harington"},null,2,"=SUBSTITUTE(B5,CHAR(32),\"\")"]
[null,"Jane    ","Austin","Jane    Austin",null,3,"=REPLACE(E7,5,3,\"\")"]
[null,"Julia    ","Roberts","Julia    Roberts",null,4,"Find & replace Feature"]
[null,"Andrew    ","Eric","Andrew    Eric",null,5,"Text to Columns Feature"]
[null,"Bob    ","Harly","Bob    Harly",null,6,"VBA Macro"]
[null,"Rocky    ","Montana","Rocky    Montana"]
[null,"Jay    ","Hope","Jay    Hope"]
[null,"Jony    ","Wilson","Jony    Wilson"]

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

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Utilizing SUBSTITUTE Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Removed Trailing Spaces","Last Name","Full Name",null,null,null,"First Name","Removed Trailing Spaces","Last Name","Full Name"]
[null,"Jane    ",{"$f":"SUBSTITUTE(B5,CHAR(32),\"\")","v":"Jane"}," Doe  ",{"$f":"C5&D5","v":"Jane Doe  "},null,null,null,"Jane    ",null,"Doe  "]
[null,"Kit    ",{"$f":"SUBSTITUTE(B6,CHAR(32),\"\")","v":"Kit"}," Harington  ",{"$f":"C6&D6","v":"Kit Harington  "},null,null,null,"Kit    ",null,"Harington  "]
[null,"Jane    ","Jane"," Austin  ","Jane Austin  ",null,null,null,"Jane    ",null,"Austin  "]
[null,"Julia    ","Julia"," Roberts  ","Julia Roberts  ",null,null,null,"Julia    ",null,"Roberts  "]
[null,"Andrew    ","Andrew"," Eric  ","Andrew Eric  ",null,null,null,"Andrew    ",null," Eric  "]
[null,"Bob    ","Bob"," Harly  ","Bob Harly  ",null,null,null,"Bob    ",null,"Harly  "]
[null,"Rocky    ","Rocky"," Montana  ","Rocky Montana  ",null,null,null,"Rocky    ",null,"Montana  "]
[null,"Jay    ","Jay"," Hope   ","Jay Hope   ",null,null,null,"Jay    ",null,"Hope   "]
[null,"Jony    ","Jony"," Wilson  ","Jony Wilson  ",null,null,null,"Jony    ",null,"Wilson  "]

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

{"sheet":"Find and Replace ","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Find and Replace Feature",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Extra Spaces","Last Name","Full Name",null,null,null,"First Name","Extra Spaces","Last Name","Full Name"]
[null,"Jane ",{"$f":"LEN(B5)-LEN(TRIM(B5))","v":1},"Doe",{"$f":"B5&D5","v":"Jane Doe"},null,null,null,"Jane    ",{"$f":"LEN(I5)-LEN(TRIM(I5))","v":4},"Doe",{"$f":"I5&K5","v":"Jane    Doe"}]
[null,"Kit ",{"$f":"LEN(B6)-LEN(TRIM(B6))","v":1},"Harington","Kit Harington",null,null,null,"Kit    ",{"$f":"LEN(I6)-LEN(TRIM(I6))","v":4},"Harington","Kit    Harington"]
[null,"Jane ",1,"Austin","Jane Austin",null,null,null,"Jane    ",4,"Austin","Jane    Austin"]
[null,"Julia ",1,"Roberts","Julia Roberts",null,null,null,"Julia    ",4,"Roberts","Julia    Roberts"]
[null,"Andrew ",1,"Eric","Andrew Eric",null,null,null,"Andrew    ",4,"Eric","Andrew    Eric"]
[null,"Bob ",1,"Harly","Bob Harly",null,null,null,"Bob    ",4,"Harly","Bob    Harly"]
[null,"Rocky ",1,"Montana","Rocky Montana",null,null,null,"Rocky    ",4,"Montana","Rocky    Montana"]
[null,"Jay ",1,"Hope","Jay Hope",null,null,null,"Jay    ",4,"Hope","Jay    Hope"]
[null,"Jony ",1,"Wilson","Jony Wilson",null,null,null,"Jony    ",4,"Wilson","Jony    Wilson"]

{"sheet":"Text to Column","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Text to Column Feature",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"B5&C5","v":"JaneDoe"},null,null,null,"Jane    ","Doe",{"$f":"H5&I5","v":"Jane    Doe"}]
[null,"Kit","Harington",{"$f":"B6&C6","v":"KitHarington"},null,null,null,"Kit    ","Harington",{"$f":"H6&I6","v":"Kit    Harington"}]
[null,"Jane","Austin",{"$f":"B7&C7","v":"JaneAustin"},null,null,null,"Jane    ","Austin",{"$f":"H7&I7","v":"Jane    Austin"}]
[null,"Julia","Roberts",{"$f":"B8&C8","v":"JuliaRoberts"},null,null,null,"Julia    ","Roberts",{"$f":"H8&I8","v":"Julia    Roberts"}]
[null,"Andrew","Eric",{"$f":"B9&C9","v":"AndrewEric"},null,null,null,"Andrew    ","Eric",{"$f":"H9&I9","v":"Andrew    Eric"}]
[null,"Bob","Harly",{"$f":"B10&C10","v":"BobHarly"},null,null,null,"Bob    ","Harly",{"$f":"H10&I10","v":"Bob    Harly"}]
[null,"Rocky","Montana",{"$f":"B11&C11","v":"RockyMontana"},null,null,null,"Rocky    ","Montana",{"$f":"H11&I11","v":"Rocky    Montana"}]
[null,"Jay","Hope",{"$f":"B12&C12","v":"JayHope"},null,null,null,"Jay    ","Hope",{"$f":"H12&I12","v":"Jay    Hope"}]
[null,"Jony","Wilson",{"$f":"B13&C13","v":"JonyWilson"},null,null,null,"Jony    ","Wilson",{"$f":"H13&I13","v":"Jony    Wilson"}]

{"sheet":"VBA Macro Code","index":7,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Applying VBA Macro Code",null,null,null,null,null,null,"Try  Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,null,"First Name","Last Name","Full Name"]
[null,"Jane","Doe",{"$f":"B5&C5","v":"JaneDoe"},null,null,null,null,"Jane    ","Doe",{"$f":"I5&J5","v":"Jane    Doe"}]
[null,"Kit","Harington",{"$f":"B6&C6","v":"KitHarington"},null,null,null,null,"Kit    ","Harington",{"$f":"I6&J6","v":"Kit    Harington"}]
[null,"Jane","Austin","JaneAustin",null,null,null,null,"Jane    ","Austin",{"$f":"I7&J7","v":"Jane    Austin"}]
[null,"Julia","Roberts","JuliaRoberts",null,null,null,null,"Julia    ","Roberts",{"$f":"I8&J8","v":"Julia    Roberts"}]
[null,"Andrew","Eric","AndrewEric",null,null,null,null,"Andrew    ","Eric",{"$f":"I9&J9","v":"Andrew    Eric"}]
[null,"Bob","Harly","BobHarly",null,null,null,null,"Bob    ","Harly",{"$f":"I10&J10","v":"Bob    Harly"}]
[null,"Rocky","Montana","RockyMontana",null,null,null,null,"Rocky    ","Montana",{"$f":"I11&J11","v":"Rocky    Montana"}]
[null,"Jay","Hope","JayHope",null,null,null,null,"Jay    ","Hope",{"$f":"I12&J12","v":"Jay    Hope"}]
[null,"Jony","Wilson","JonyWilson",null,null,null,null,"Jony    ","Wilson",{"$f":"I13&J13","v":"Jony    Wilson"}]

{"sheet":"for Numbers","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Removing Trailing Space from Numbers",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Full Name","Password with Space","Password Without Space",null,null,null,null,"Full Name","Password with Space","Password Without Space"]
[null,"Jane Doe","123   Jane",{"$f":"TRIM(C5)","v":"123 Jane"},null,null,null,null,"Jane Doe","123   Jane"]
[null,"Kit Harington","827   Kit",{"$f":"TRIM(C6)","v":"827 Kit"},null,null,null,null,"Kit Harington","827   Kit"]
[null,"Jane Austin","637   Jane","637 Jane",null,null,null,null,"Jane Austin","637   Jane"]
[null,"Julia Roberts","882   Julia","882 Julia",null,null,null,null,"Julia Roberts","882   Julia"]
[null,"Andrew Eric","182   Eric","182 Eric",null,null,null,null,"Andrew Eric","182   Eric"]
[null,"Bob Harly","999   Bob","999 Bob",null,null,null,null,"Bob Harly","999   Bob"]
[null,"Rocky Montana","102   Rocky","102 Rocky",null,null,null,null,"Rocky Montana","102   Rocky"]
[null,"Jay Hope","8374   Jay","8374 Jay",null,null,null,null,"Jay Hope","8374   Jay"]
[null,"Jony Wilson","664   Jony","664 Jony",null,null,null,null,"Jony Wilson","664   Jony"]