{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset 1","Carriage Return","Dataset 2","Word Delimiter","Dataset 3","Removing Carriage Return"],"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 1","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Personal Details of Employees"]
[]
[null,"Personal Details","Name","Account Number","Family Members","Age"]
[null,"Adam Willis\n880234\n5\n45"]
[null,"Samantha Wheeler\n880235\n4\n35"]
[null,"Charlie Adams\n880236\n5\n26"]
[null,"Amy Jackson\n880237\n3\n33"]

{"sheet":"Carriage Return","index":1,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Text to Columns Feature with Carriage Return",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Personal Details","Name","Account Number","Family Members","Age",null,null,null,null,null,"Personal Details","Name","Account Number","Family Members","Age"]
[null,"Adam Willis\n880234\n5\n45","Adam Willis",880234,5,45,null,null,null,null,null,"Adam Willis\n880234\n5\n45"]
[null,"Samantha Wheeler\n880235\n4\n35","Samantha Wheeler",880235,4,35,null,null,null,null,null,"Samantha Wheeler\n880235\n4\n35"]
[null,"Charlie Adams\n880236\n5\n26","Charlie Adams",880236,5,26,null,null,null,null,null,"Charlie Adams\n880236\n5\n26"]
[null,"Amy Jackson\n880237\n3\n33","Amy Jackson",880237,3,33,null,null,null,null,null,"Amy Jackson\n880237\n3\n33"]

{"sheet":"Dataset 2","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Personal Details of Employees"]
[]
[null,"Personal Details","Name","Account Number"]
[null,"Adam Willis Acc: 880234"]
[null,"Samantha Wheeler Acc: 880235"]
[null,"Charlie Adams Acc: 880236"]
[null,"Amy Jackson Acc: 880237"]

{"sheet":"Word Delimiter","index":3,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Personal Details of Employees",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Personal Details","Name","Account Number",null,null,null,null,null,"Personal Details","Name","Account Number"]
[null,"Adam Willis , 880234","Adam Willis ",880234,null,null,null,null,null,"Adam Willis Acc: 880234"]
[null,"Samantha Wheeler , 880235","Samantha Wheeler ",880235,null,null,null,null,null,"Samantha Wheeler Acc: 880235"]
[null,"Charlie Adams , 880236","Charlie Adams ",880236,null,null,null,null,null,"Charlie Adams Acc: 880236"]
[null,"Amy Jackson , 880237","Amy Jackson ",880237,null,null,null,null,null,"Amy Jackson Acc: 880237"]

{"sheet":"Dataset 3","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Removing Carriage Return with Text to Columns"]
[]
[]
[null,"Name","Adam Willis\n880234\n5\n45","Samantha Wheeler\n880235\n4\n35","Charlie Adams\n880236\n5\n26"]
[null,"Account Number"]
[null,"Family Members"]
[null,"Age"]

{"sheet":"Removing Carriage Return","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Removing Carriage Return with Text to Columns"]
[]
[null,"Name","Adam Willis","Samantha Wheeler","Charlie Adams"]
[null,"Account Number",880234,880235,880236]
[null,"Family Members",5,4,5]
[null,"Age",45,35,26]