{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","RIGHT Function","Flash Fill Option","Text to Column Feature","Replace Function","VBA 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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Name","Truncated Text"]
[null,"Shane Austin"]
[null,"Natasha Moorie"]
[null,"Gregory Taylor"]
[null,"Alex Stokes"]
[null,"Alisha Milton"]

{"sheet":"RIGHT Function","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of RIGHT Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Truncated Text",null,null,null,null,null,null,"Name","Truncated Text"]
[null,"Shane Austin",{"$f":"RIGHT(B5,6)","v":"Austin"},null,null,null,null,null,null,"Shane Austin"]
[null,"Natasha Moorie",{"$f":"RIGHT(B6,6)","v":"Moorie"},null,null,null,null,null,null,"Natasha Moorie"]
[null,"Gregory Taylor","Taylor",null,null,null,null,null,null,"Gregory Taylor"]
[null,"Alex Stokes","Stokes",null,null,null,null,null,null,"Alex Stokes"]
[null,"Alisha Milton","Milton",null,null,null,null,null,null,"Alisha Milton"]

{"sheet":"Flash Fill Option","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of Flash Fill Tool",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Truncated Text",null,null,null,null,null,null,"Name","Truncated Text"]
[null,"Shane Austin","Austin",null,null,null,null,null,null,"Shane Austin"]
[null,"Natasha Moorie","Moorie",null,null,null,null,null,null,"Natasha Moorie"]
[null,"Gregory Taylor","Taylor",null,null,null,null,null,null,"Gregory Taylor"]
[null,"Alex Stokes","Stokes",null,null,null,null,null,null,"Alex Stokes"]
[null,"Alisha Milton","Milton",null,null,null,null,null,null,"Alisha Milton"]

{"sheet":"Text to Column Feature","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of Text to Columns Feature",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Truncated Text",null,null,null,null,null,null,"Name","Truncated Text"]
[null,"11001 Austin","Austin",null,null,null,null,null,null,"11001 Austin"]
[null,"11002 Moorie","Moorie",null,null,null,null,null,null,"11002 Moorie"]
[null,"11003 Taylor","Taylor",null,null,null,null,null,null,"11003 Taylor"]
[null,"11004 Stokes","Stokes",null,null,null,null,null,null,"11004 Stokes"]
[null,"11005 Milton","Milton",null,null,null,null,null,null,"11005 Milton"]

{"sheet":"Replace Function","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of REPLACE Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Truncated Text",null,null,null,null,null,null,"Name","Truncated Text"]
[null,"11001 Austin",{"$f":"REPLACE(B5, 1, 6, \"\")","v":"Austin"},null,null,null,null,null,null,"11001 Austin"]
[null,"11002 Moorie",{"$f":"REPLACE(B6, 1,6, \"\")","v":"Moorie"},null,null,null,null,null,null,"11002 Moorie"]
[null,"11003 Taylor",{"$f":"REPLACE(B7, 1, 6, \"\")","v":"Taylor"},null,null,null,null,null,null,"11003 Taylor"]
[null,"11004 Stokes","Stokes",null,null,null,null,null,null,"11004 Stokes"]
[null,"11005 Milton","Milton",null,null,null,null,null,null,"11005 Milton"]

{"sheet":"VBA Code","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,"Use of VBA Code",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Truncated Text",null,null,null,null,null,null,"Name","Truncated Text"]
[null,"11001 Austin",{"$f":"TruncatefromRight(B5,6)","v":"Austin"},null,null,null,null,null,null,"11001 Austin"]
[null,"11002 Moorie",{"$f":"TruncatefromRight(B6,6)","v":"Moorie"},null,null,null,null,null,null,"11002 Moorie"]
[null,"11003 Taylor",{"$f":"TruncatefromRight(B7,6)","v":"Taylor"},null,null,null,null,null,null,"11003 Taylor"]
[null,"11004 Stokes",{"$f":"TruncatefromRight(B8,6)","v":"Stokes"},null,null,null,null,null,null,"11004 Stokes"]
[null,"11005 Milton",{"$f":"TruncatefromRight(B9,6)","v":"Milton"},null,null,null,null,null,null,"11005 Milton"]