{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Dataset","SPLIT Function","TEXTSPLIT Function"],"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":"Overview","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[12,2,12,4]]}
[]
[null,"Overview of VBA Split String with Multiple Delimiters"]
[]
[null,"Student's Information","Student Name","Student ID","Department"]
[null,"John,1512-Physics","John",1512,"Physics"]
[null,"Max,1513-Math","Max",1513,"Math"]
[null,"Lewis,1523-Economics","Lewis",1523,"Economics"]
[null,"Paul,1614-History","Paul",1614,"History"]
[null,"Thomas,1315-Physics","Thomas",1315,"Physics"]
[null,"Anna,1414-Chemistry","Anna",1414,"Chemistry"]
[null,"Merry,1516-Math","Merry",1516,"Math"]
[null,"Williams,1313-Pharmacy","Williams",1313,"Pharmacy"]
[null,">> Combined Strings",">> Divided Strings"]

{"sheet":"Dataset","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,10,1,13]]}
[]
[null,"Student's Information of ABC College",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Student's Information",null,null,null,null,null,null,null,null,"Student's Information","Student Name","Student ID","Department"]
[null,"John 1512-Physics",null,null,null,null,null,null,null,null,"John,1512-Physics"]
[null,"Max 1513-Math",null,null,null,null,null,null,null,null,"Max,1513-Math"]
[null,"Lewis 1523-Economics",null,null,null,null,null,null,null,null,"Lewis,1523-Economics"]
[null,"Paul 1614-History",null,null,null,null,null,null,null,null,"Paul,1614-History"]
[null,"Thomas 1315-Physics",null,null,null,null,null,null,null,null,"Thomas,1315-Physics"]
[null,"Anna 1414-Chemistry",null,null,null,null,null,null,null,null,"Anna,1414-Chemistry"]
[null,"Merry 1516-Math",null,null,null,null,null,null,null,null,"Merry,1516-Math"]
[null,"Williams 1313-Pharmacy",null,null,null,null,null,null,null,null,"Williams,1313-Pharmacy"]

{"sheet":"SPLIT Function","index":2,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Splitting Multiple Delimiters with VBA",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Student's Information","Student Name","Student ID","Department",null,null,null,null,null,"Student's Information","Student Name","Student ID","Department"]
[null,"John,1512-Physics","John",1512,"Physics",null,null,null,null,null,"John,1512-Physics"]
[null,"Max,1513-Math","Max",1513,"Math",null,null,null,null,null,"Max,1513-Math"]
[null,"Lewis,1523-Economics","Lewis",1523,"Economics",null,null,null,null,null,"Lewis,1523-Economics"]
[null,"Paul,1614-History","Paul",1614,"History",null,null,null,null,null,"Paul,1614-History"]
[null,"Thomas,1315-Physics","Thomas",1315,"Physics",null,null,null,null,null,"Thomas,1315-Physics"]
[null,"Anna,1414-Chemistry","Anna",1414,"Chemistry",null,null,null,null,null,"Anna,1414-Chemistry"]
[null,"Merry,1516-Math","Merry",1516,"Math",null,null,null,null,null,"Merry,1516-Math"]
[null,"Williams,1313-Pharmacy","Williams",1313,"Pharmacy",null,null,null,null,null,"Williams,1313-Pharmacy"]

{"sheet":"TEXTSPLIT Function","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using Multiple Delimiters to Split String Without VBA",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Student's Information","Student Name","Student ID","Department",null,null,null,null,null,"Student's Information","Student Name","Student ID","Department"]
[null,"John,1512-Physics",{"$f":"_xlfn.TEXTSPLIT(B5,{\",\",\"-\"})","v":"John"},"1512","Physics",null,null,null,null,null,"John,1512-Physics"]
[null,"Max,1513-Math",{"$f":"_xlfn.TEXTSPLIT(B6,{\",\",\"-\"})","v":"Max"},"1513","Math",null,null,null,null,null,"Max,1513-Math"]
[null,"Lewis,1523-Economics",{"$f":"_xlfn.TEXTSPLIT(B7,{\",\",\"-\"})","v":"Lewis"},"1523","Economics",null,null,null,null,null,"Lewis,1523-Economics"]
[null,"Paul,1614-History",{"$f":"_xlfn.TEXTSPLIT(B8,{\",\",\"-\"})","v":"Paul"},"1614","History",null,null,null,null,null,"Paul,1614-History"]
[null,"Thomas,1315-Physics",{"$f":"_xlfn.TEXTSPLIT(B9,{\",\",\"-\"})","v":"Thomas"},"1315","Physics",null,null,null,null,null,"Thomas,1315-Physics"]
[null,"Anna,1414-Chemistry",{"$f":"_xlfn.TEXTSPLIT(B10,{\",\",\"-\"})","v":"Anna"},"1414","Chemistry",null,null,null,null,null,"Anna,1414-Chemistry"]
[null,"Merry,1516-Math",{"$f":"_xlfn.TEXTSPLIT(B11,{\",\",\"-\"})","v":"Merry"},"1516","Math",null,null,null,null,null,"Merry,1516-Math"]
[null,"Williams,1313-Pharmacy",{"$f":"_xlfn.TEXTSPLIT(B12,{\",\",\"-\"})","v":"Williams"},"1313","Pharmacy",null,null,null,null,null,"Williams,1313-Pharmacy"]