{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main","Clean Function ","Trim Function","Substitute","Find & Replace","VBA"],"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":"Main","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name"]
[null,"John Webster","Duches \nof \nMalfi "]
[null,"Jane Austen ","Pride \nand \n Prejudice "]
[null,"Robert Frost ","The Road Not\n Taken "]
[null,"Toni Morrison ","Song of\n Solomon "]
[null,"J.K Rowling ","Harry \nPorter"]

{"sheet":"Clean Function ","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name","Result "]
[null,"John Webster","Duches \nof \nMalfi ",{"$f":"CLEAN(C5)","v":"Duches of Malfi "}]
[null,"Jane Austen ","Pride\nand \nPrejudice",{"$f":"CLEAN(C6)","v":"Prideand Prejudice"}]
[null,"Robert Frost ","The Road Not \nTaken ",{"$f":"CLEAN(C7)","v":"The Road Not Taken "}]
[null,"Toni Morrison ","Song of\n Solomon ",{"$f":"CLEAN(C8)","v":"Song of Solomon "}]
[null,"J.K Rowling ","Harry \nPorter",{"$f":"CLEAN(C9)","v":"Harry Porter"}]

{"sheet":"Trim Function","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name","Result "]
[null,"John Webster","Duches \nof \nMalfi ",{"$f":"TRIM(C5)","v":"Duches \nof \nMalfi"}]
[null,"Jane Austen ","Pride\n  and \nPrejudice",{"$f":"TRIM(C6)","v":"Pride\n and \nPrejudice"}]
[null,"Robert Frost ","The Road Not \nTaken ",{"$f":"TRIM(C7)","v":"The Road Not \nTaken"}]
[null,"Toni Morrison ","Song of\n Solomon ",{"$f":"TRIM(C8)","v":"Song of\n Solomon"}]
[null,"J.K Rowling ","Harry \nPorter",{"$f":"TRIM(C9)","v":"Harry \nPorter"}]

{"sheet":"Substitute","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name","Result "]
[null,"John Webster","Duches \nof \nMalfi ",{"$f":"SUBSTITUTE(C5,CHAR(10),\"\")","v":"Duches of Malfi "}]
[null,"Jane Austen ","Pride\n  and \nPrejudice",{"$f":"SUBSTITUTE(C6,CHAR(10),\"\")","v":"Pride  and Prejudice"}]
[null,"Robert Frost ","The Road Not \nTaken ",{"$f":"SUBSTITUTE(C7,CHAR(10),\"\")","v":"The Road Not Taken "}]
[null,"Toni Morrison ","Song of\n Solomon ",{"$f":"SUBSTITUTE(C8,CHAR(10),\"\")","v":"Song of Solomon "}]
[null,"J.K Rowling ","Harry \nPorter",{"$f":"SUBSTITUTE(C9,CHAR(10),\"\")","v":"Harry Porter"}]

{"sheet":"Find & Replace","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name","Result "]
[null,"John Webster","Duches \nof \nMalfi ","Duches of Malfi "]
[null,"Jane Austen ","Pride\n and \n Prejudice ","Pride and  Prejudice "]
[null,"Robert Frost ","The Road Not \nTaken ","The Road Not Taken "]
[null,"Toni Morrison ","Song of\n Solomon ","Song of Solomon "]
[null,"J.K Rowling ","Harry \nPorter","Harry Porter"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Remove Line Breaks in Excel"]
[]
[null,"Author ","Book Name"]
[null,"John Webster","Duches of Malfi "]
[null,"Jane Austen ","Pride and  Prejudice "]
[null,"Robert Frost ","The Road Not Taken "]
[null,"Toni Morrison ","Song of Solomon "]
[null,"J.K Rowling ","Harry Porter"]