{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["main","lineSpace","commaReplace","LineBreakReplace","separateSheet","separateSheet (2)","singlerow","dowhile"],"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Split String into Rows Using Excel VBA"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel Phoebe"]
[null,"Academic","Joey Ross"]
[null,"Data Analyst","Chandler"]
[null,"Chef","Monica"]

{"sheet":"lineSpace","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Split String Separated with Line Space",null,null,null,null,"Practice"]
[]
[null,"Occupation","Name",null,null,null,"Occupation","Name"]
[null,"Sales","Rachel Phoebe",null,null,null,"Sales","Rachel Phoebe"]
[null,"Academic","Joey Ross",null,null,null,"Academic","Joey Ross"]
[null,"Data Analyst","Chandler",null,null,null,"Data Analyst","Chandler"]
[null,"Chef","Monica",null,null,null,"Chef","Monica"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel"]
[null,"Sales","Phoebe"]
[null,"Academic","Joey"]
[null,"Academic","Ross"]
[null,"Data Analyst","Chandler"]
[null,"Chef","Monica"]

{"sheet":"commaReplace","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,5,14,6],[1,1,1,2]]}
[]
[null,"Split String and Replace Original Data"]
[]
[null,"Name","Occupation"]
[null,"Rachel","Sales"]
[null,"Phoebe","Sales"]
[null,"Joey","Academic"]
[null,"Ross","Academic"]
[null,"Chandler","Data Analyst"]
[null,"Monica","Chef"]
[]
[]
[]
[]
[null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,"Name","Occupation"]
[null,null,null,null,null,"Rachel,Phoebe","Sales"]
[null,null,null,null,null,"Joey,Ross","Academic"]
[null,null,null,null,null,"Chandler","Data Analyst"]
[null,null,null,null,null,"Monica","Chef"]

{"sheet":"LineBreakReplace","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2],[11,5,11,6]]}
[]
[null,"Split Strings into Rows with Line Break"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel "]
[null,"Sales","Phoebe"]
[null,"Academic","Joey "]
[null,"Academic","Ross"]
[null,"Data Analyst","Chandler"]
[null,"Chef","Monica"]
[]
[null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,"Occupation","Name"]
[null,null,null,null,null,"Sales","Rachel \nPhoebe"]
[null,null,null,null,null,"Academic","Joey \nRoss"]
[null,null,null,null,null,"Data Analyst","Chandler"]
[null,null,null,null,null,"Chef","Monica"]

{"sheet":"separateSheet","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,2],[20,5,20,6]]}
[]
[null,"Split Strings into Rows (Separate Sheet)"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel Green;Phoebe Buffay"]
[null,"Academic","Joey Tribbiani;Ross Geller"]
[null,"Data Analyst","Chandler Bing"]
[null,"Chef","Monica Geller"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,"Occupation","Name"]
[null,null,null,null,null,"Sales","Rachel Green;Phoebe Buffay"]
[null,null,null,null,null,"Academic","Joey Tribbiani;Ross Geller"]
[null,null,null,null,null,"Data Analyst","Chandler Bing"]
[null,null,null,null,null,"Chef","Monica Geller"]

{"sheet":"separateSheet (2)","index":5,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,2],[17,6,17,7]]}
[]
[null,"Split Strings into Rows (Separate Sheet)"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel Green"]
[null,"Sales","Phoebe Buffay"]
[null,"Academic","Joey Tribbiani"]
[null,"Academic","Ross Geller"]
[null,"Data Analyst","Chandler Bing"]
[null,"Chef","Monica Geller"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,null,"Occupation","Name"]
[null,null,null,null,null,null,"Sales","Rachel Green;Phoebe Buffay"]
[null,null,null,null,null,null,"Academic","Joey Tribbiani;Ross Geller"]
[null,null,null,null,null,null,"Data Analyst","Chandler Bing"]
[null,null,null,null,null,null,"Chef","Monica Geller"]

{"sheet":"singlerow","index":6,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"For a Single Row",null,null,null,null,null,"Practice"]
[]
[null,"Occupation","Name",null,null,null,null,"Occupation","Name"]
[null,"Sales,HR","Rachel,Phoebe",null,null,null,null,"Sales,HR","Rachel,Phoebe"]
[null,"Actor","Joey",null,null,null,null,"Actor","Joey"]
[null,"Data Analyst","Chandler",null,null,null,null,"Data Analyst","Chandler"]
[null,"Chef","Monica",null,null,null,null,"Chef","Monica"]
[]
[null,"Sales","Rachel"]
[null,"HR","Phoebe"]

{"sheet":"dowhile","index":7,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,2],[19,6,19,7]]}
[]
[null,"Split String into Rows Using Do While Statement"]
[]
[null,"Occupation","Name"]
[null,"Sales","Rachel"]
[null,null,"Phoebe"]
[null,"Actor","Joey"]
[null,null,"Ross"]
[null,"Data Analyst","Chandler"]
[null,"Chef","Monica"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,null,"Occupation","Name"]
[null,null,null,null,null,null,"Sales","Rachel,Phoebe"]
[null,null,null,null,null,null,"Actor","Joey,Ross"]
[null,null,null,null,null,null,"Data Analyst","Chandler"]
[null,null,null,null,null,null,"Chef","Monica"]