{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Text to Column","VBA ","Using Formula"],"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":"Text to Column","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Text to Columns from Data Tab"]
[]
[null,"Address","Name","Street ","City ","Country"]
[null,"Elijah Williams\n187 Clousson Road\nIowa\nUnited States","Elijah Williams","187 Clousson Road","Iowa","United States"]
[null,"Jim Hopper\n 4838 Adamsville Road\nTexas\n United States","Jim Hopper"," 4838 Adamsville Road","Texas","United States"]
[null,"Daniel James\n4010 American Drive\nFlorida\nUnited States","Daniel James","4010 American Drive","Florida","United States"]
[null,"Jane Hopper\n949 Kidd Avenue\nAlaska\nUnited States","Jane Hopper","949 Kidd Avenue","Alaska","United States"]

{"sheet":"VBA ","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Embedding VBA to Use Line Break as Delimiter"]
[]
[null,"Address","Name","Street ","City ","Country"]
[null,"Elijah Williams\n187 Clousson Road\nIowa\nUnited States","Elijah Williams","187 Clousson Road","Iowa","United States"]
[null,"Jim Hopper\n 4838 Adamsville Road\nTexas\n United States","Jim Hopper"," 4838 Adamsville Road","Texas"," United States"]
[null,"Daniel James\n4010 American Drive\nFlorida\nUnited States","Daniel James","4010 American Drive","Florida","United States"]
[null,"Jane Hopper\n949 Kidd Avenue\nAlaska\nUnited States","Jane Hopper","949 Kidd Avenue","Alaska","United States"]

{"sheet":"Using Formula","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Splitting Cell by Line Break Using Formula"]
[]
[null,"Text ","Item ","Color","Size"]
[null,"Denim\nBlue\nM",{"$f":"LEFT(B5, SEARCH(CHAR(10),B5,1)-1)","v":"Denim"},{"$f":"MID(B5, SEARCH(CHAR(10),B5) + 1, SEARCH(CHAR(10),B5,SEARCH(CHAR(10),B5)+1) - SEARCH(CHAR(10),B5) - 1)","v":"Blue"},{"$f":"RIGHT(B5,LEN(B5) - SEARCH(CHAR(10), B5, SEARCH(CHAR(10), B5) + 1))","v":"M"}]
[null,"T-Shirt\nWhite\nXL",{"$f":"LEFT(B6, SEARCH(CHAR(10),B6,1)-1)","v":"T-Shirt"},{"$f":"MID(B6, SEARCH(CHAR(10),B6) + 1, SEARCH(CHAR(10),B6,SEARCH(CHAR(10),B6)+1) - SEARCH(CHAR(10),B6) - 1)","v":"White"},{"$f":"RIGHT(B6,LEN(B6) - SEARCH(CHAR(10), B6, SEARCH(CHAR(10), B6) + 1))","v":"XL"}]
[null,"Shirt\nBlack\nL","Shirt","Black","L"]
[null,"Skirt\nPink\nL","Skirt","Pink","L"]