{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Inputs","Using Find & Replace Option","Utilizing a Text Editor","Combining SUBSTITUTE & CHAR","Using CLEAN Function","Applying a VBA Code","Using Power Query Tool","Table2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sample Inputs","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample Inputs"]
[]
[null,"Input"]
[null,"Sara got \t78 marks in the exam"]
[null,"John got \t75 marks in the exam"]
[null,"Williams got \t58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam"]
[null,"Alex got \t74 marks in the exam"]

{"sheet":"Using Find & Replace Option","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Find & Replace Dialogue Box"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam","Sara got 78 marks in the exam"]
[null,"John got \t75 marks in the exam","John got 75 marks in the exam"]
[null,"Williams got \t58 marks in the exam","Williams got 58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got 70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got 74 marks in the exam"]

{"sheet":"Utilizing a Text Editor","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing a Text Editor"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam","Sara got 78 marks in the exam"]
[null,"John got \t75 marks in the exam","John got 75 marks in the exam"]
[null,"Williams got \t58 marks in the exam","Williams got 58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got 70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got 74 marks in the exam"]

{"sheet":"Combining SUBSTITUTE & CHAR","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining TRIM, SUBSTITUTE & CHAR Function"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam",{"$f":"TRIM(SUBSTITUTE(B5,CHAR(9),\"\"))","v":"Sara got 78 marks in the exam"}]
[null,"John got \t75 marks in the exam",{"$f":"TRIM(SUBSTITUTE(B6,CHAR(9),\"\"))","v":"John got 75 marks in the exam"}]
[null,"Williams got \t58 marks in the exam","Williams got 58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got 70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got 74 marks in the exam"]

{"sheet":"Using CLEAN Function","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using CLEAN Function"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam",{"$f":"CLEAN(B5)","v":"Sara got 78 marks in the exam"}]
[null,"John got \t75 marks in the exam",{"$f":"CLEAN(B6)","v":"John got 75 marks in the exam"}]
[null,"Williams got \t58 marks in the exam","Williams got 58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got 70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got 74 marks in the exam"]

{"sheet":"Applying a VBA Code","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying a VBA Code"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam","Sara got 78 marks in the exam"]
[null,"John got \t75 marks in the exam","John got 75 marks in the exam"]
[null,"Williams got \t58 marks in the exam","Williams got 58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got 70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got 74 marks in the exam"]

{"sheet":"Using Power Query Tool","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power Query Tool"]
[]
[null,"Input","Output"]
[null,"Sara got \t78 marks in the exam","Sara got \t78 marks in the exam"]
[null,"John got \t75 marks in the exam","John got \t75 marks in the exam"]
[null,"Williams got \t58 marks in the exam","Williams got \t58 marks in the exam"]
[null,"Lucy got \t70 marks in the exam","Lucy got \t70 marks in the exam"]
[null,"Alex got \t74 marks in the exam","Alex got \t74 marks in the exam"]

{"sheet":"Table2","index":7,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Output"]
["Sara got 78 marks in the exam"]
["John got 75 marks in the exam"]
["Williams got 58 marks in the exam"]
["Lucy got 70 marks in the exam"]
["Alex got 74 marks in the exam"]