{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Clean Function","SUBSTITUTE Function ","Replace","VBA Method"],"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,"Status","Student Name"]
[null,"Containing  Non Printable Character 11",{"$f":"\"Jane Austin\"&CHAR(11)","v":"Jane Austin\u000b"}]
[null,"Containing  Non Printable Character 7",{"$f":"CHAR(7)&\"Rocky Montana\"&CHAR(7)","v":"\u0007Rocky Montana\u0007"}]
[null,"Containing  Non Printable Character 12",{"$f":"CHAR(12)&\"Tom Cruse\"&CHAR(12)","v":"\fTom Cruse\f"}]
[null,"Containing  Non Printable Character 15",{"$f":"CHAR(15)&\"Brayan Taylor\"","v":"\u000fBrayan Taylor"}]
[null,"Containing Non Printable Space","Tom     Jenkings "]

{"sheet":"Clean Function","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using CLEAN Function"]
[]
[null,"Status","Student Name","Clean Function "]
[null,"Containing  Non Printable Character 11",{"$f":"\"Jane Austin\"&CHAR(11)","v":"Jane Austin\u000b"},{"$f":"CLEAN(C5)","v":"Jane Austin"}]
[null,"Containing  Non Printable Character 7",{"$f":"CHAR(7)&\"Rocky Montana\"&CHAR(7)","v":"\u0007Rocky Montana\u0007"},{"$f":"CLEAN(C6)","v":"Rocky Montana"}]
[null,"Containing  Non Printable Character 12",{"$f":"CHAR(12)&\"Tom Cruse\"&CHAR(12)","v":"\fTom Cruse\f"},{"$f":"CLEAN(C7)","v":"Tom Cruse"}]
[null,"Containing  Non Printable Character 15",{"$f":"CHAR(15)&\"Brayan Taylor\"","v":"\u000fBrayan Taylor"},"Brayan Taylor"]

{"sheet":"SUBSTITUTE Function ","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using SUBSTITUTE Function"]
[]
[null,"Status","Student Name","SUBSTITUTE Function "]
[null,"Containing  Non Printable Character 11",{"$f":"\"Jane Austin\"&CHAR(11)","v":"Jane Austin\u000b"},{"$f":"SUBSTITUTE(C5,CHAR(11),\"\")","v":"Jane Austin"}]
[null,"Containing  Non Printable Character 7",{"$f":"CHAR(7)&\"Rocky Montana\"&CHAR(7)","v":"\u0007Rocky Montana\u0007"},{"$f":"SUBSTITUTE(C6,CHAR(7),\"\")","v":"Rocky Montana"}]
[null,"Containing  Non Printable Character 12",{"$f":"CHAR(12)&\"Tom Cruse\"&CHAR(12)","v":"\fTom Cruse\f"},{"$f":"SUBSTITUTE(C7,CHAR(12),\"\")","v":"Tom Cruse"}]
[null,"Containing  Non Printable Character 15",{"$f":"CHAR(15)&\"Brayan Taylor\"","v":"\u000fBrayan Taylor"},{"$f":"SUBSTITUTE(C8,CHAR(15),\"\")","v":"Brayan Taylor"}]
[null,"Containing Non Printable Space","Tom       Jenkings ",{"$f":"SUBSTITUTE(C9,\"  \",\"\")","v":"Tom Jenkings "}]

{"sheet":"Replace","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Find and Replace Feature"]
[]
[null,"Status","Student Name"]
[null,"Containing  Non Printable Character 11",{"$f":"\"Jane Austin\"&CHAR(32)","v":"Jane Austin "}]
[null,"Containing  Non Printable Character 7",{"$f":"CHAR(32)&\"Rocky Montana\"&CHAR(32)","v":" Rocky Montana "}]
[null,"Containing  Non Printable Character 12",{"$f":"CHAR(32)&\"Tom Cruse\"&CHAR(32)","v":" Tom Cruse "}]
[null,"Containing  Non Printable Character 15",{"$f":"CHAR(32)&\"Brayan Taylor\"","v":" Brayan Taylor"}]

{"sheet":"VBA Method","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA"]
[]
[null,"Status","Student Name","VBA Method"]
[null,"Containing  Non Printable Character 11",{"$f":"\"Jane Austin\"&CHAR(11)","v":"Jane Austin\u000b"},{"$f":"RemoveNP(C5)","v":"Jane Austin "}]
[null,"Containing  Non Printable Character 7",{"$f":"CHAR(7)&\"Rocky Montana\"&CHAR(7)","v":"\u0007Rocky Montana\u0007"},{"$f":"RemoveNP(C6)","v":" Rocky Montana "}]
[null,"Containing  Non Printable Character 12",{"$f":"CHAR(12)&\"Tom Cruse\"&CHAR(12)","v":"\fTom Cruse\f"},{"$f":"RemoveNP(C7)","v":" Tom Cruse "}]
[null,"Containing  Non Printable Character 15",{"$f":"CHAR(15)&\"Brayan Taylor\"","v":"\u000fBrayan Taylor"}," Brayan Taylor"]