{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","REPLACE ","LEFT and LEN","VBA Macro Method","VALUE LEFT and LEN","Flash Fill "],"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Employee Details (Name and ID)","Erroneous Name ","Erroneous ID"]
[null,"Jane Doe 123","Jane Doe*","123*"]
[null,"Kit Harington 124","Kit Harington_","124_"]
[null,"Jane Austin 125","Jane Austin&","125&"]
[null,"Julia Roberts 126","Julia Roberts^","126^"]
[null,"Andrew Eric 127","Andrew Eric!","127!"]
[null,"Bob Harly 128","Bob Harly@","128@"]
[null,"Rocky Montana 129","Rocky Montana$","129$"]
[null,"Jay Hope 130","Jay Hope%","130>"]
[null,"Jony Wilson 131","Jony Wilson^","131^"]

{"sheet":"REPLACE ","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Last Character From String"]
[null,"Erroneous Name ","Last Character Removed"]
[null,"Jane Doe*",{"$f":"REPLACE(B4,9,1,\" \")","v":"Jane Doe "}]
[null,"Kit Harington_",{"$f":"REPLACE(B5,14,1,\" \")","v":"Kit Harington "}]
[null,"Jane Austin&",{"$f":"REPLACE(B6,12,1,\" \")","v":"Jane Austin "}]
[null,"Julia Roberts^",{"$f":"REPLACE(B7,14,1,\" \")","v":"Julia Roberts "}]
[null,"Andrew Eric!",{"$f":"REPLACE(B8,12,1,\" \")","v":"Andrew Eric "}]
[null,"Bob Harly@",{"$f":"REPLACE(B9,10,1,\" \")","v":"Bob Harly "}]
[null,"Rocky Montana$",{"$f":"REPLACE(B10,14,1,\" \")","v":"Rocky Montana "}]
[null,"Jay Hope%",{"$f":"REPLACE(B11,9,1,\" \")","v":"Jay Hope "}]
[null,"Jony Wilson^",{"$f":"REPLACE(B12,12,1,\" \")","v":"Jony Wilson "}]

{"sheet":"LEFT and LEN","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Last Character From String"]
[null,"Erroneous Name ","Last Character Removed"]
[null,"Jane Doe*",{"$f":"LEFT(B4, LEN(B4) - 1)","v":"Jane Doe"}]
[null,"Kit Harington_",{"$f":"LEFT(B5, LEN(B5) - 1)","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":"VBA Macro Method","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Last Character From String"]
[null,"Erroneous Name ","Last Character Removed"]
[null,"Jane Doe*",{"$f":"RemoveLC(B4,1)","v":"Jane Doe"}]
[null,"Kit Harington_",{"$f":"RemoveLC(B5,1)","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":"VALUE LEFT and LEN","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Last Character From String"]
[null,"Erroneous ID","Last Character Removed"]
[null,"123*",{"$f":"VALUE(LEFT(B4,LEN(B4)-1))","v":123}]
[null,"124_",{"$f":"VALUE(LEFT(B5,LEN(B5)-1))","v":124}]
[null,"125&",125]
[null,"126^",126]
[null,"127!",127]
[null,"128@",128]
[null,"129$",129]
[null,"130>",130]
[null,"131^",131]

{"sheet":"Flash Fill ","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Removing Last Character From String"]
[null,"Erroneous ID","Last Character Removed"]
[null,"123*",123]
[null,"124_",124]
[null,"125&",125]
[null,"126^",126]
[null,"127!",127]
[null,"128@",128]
[null,"129$",129]
[null,"130>",130]
[null,"131^",131]