{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sample","Split","Limit","Sentence","Compare","Non-printable","FileExt","State","Multiple"],"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":"Sample","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Sales Rep","Product","Rev Earned"]
[null,"John","Keyboard",6548]
[null,"Alex","Printer",9382]
[null,"Wendy","Scanner",4573]
[null,"Gary","Headset",3728]
[null,"Claire","Scanner",5384]
[null,"Drew","Printer",8523]

{"sheet":"Split","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use Split Function to Split String by Delimiter"]
[]
[null,"Sales Rep","Product","Rev Earned"]
[null,"John","Keyboard",6548]
[null,"Alex","Printer",9382]
[null,"Wendy","Scanner",4573]
[null,"Gary","Headset",3728]
[null,"Claire","Scanner",5384]
[null," Drew","Printer",8523]

{"sheet":"Limit","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Specific Times Using Limit Parameter"]
[]
[null,"Sales Rep","Product","Rev Earned"]
[null,"John","Keyboard",6548]
[null,"Alex"," Printer",9382]
[null,"Wendy"," Scanner",4573]
[null,"Gary"," Headset, Scanner",3728]

{"sheet":"Sentence","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Splitting Words from A Sentence in Multiple Columns"]
[]
[null,"Sentence","Word 1","Word 2","Word 3"]
[null,"Dreams Comes True","Dreams","Comes",true]
[null,"All is Well","All","is","Well"]
[null,"Never Give Up","Never","Give","Up"]
[null,"Against All Odds","Against","All","Odds"]
[null,"Believe in Yourself","Believe","in","Yourself"]
[null,"Never Look Back","Never","Look","Back"]

{"sheet":"Compare","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split String by Delimiter Using Compare Parameter"]
[]
[null,"Sales Rep","Product","Rev Earned"]
[null,"John","Keyboard",6548]
[null,"Alex","Printer",9382]
[null,"Wendy","Scanner",4573]
[null,"Gary","Headset",3728]
[null,"Claire","Scanner",5384]
[null,"Drew","Printer",8523]

{"sheet":"Non-printable","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Non-Printable Character As Delimiter"]
[]
[null,"Sales Rep","Product","Rev Earned"]
[null,"John","Keyboard",6548]
[null,"Alex","Printer",9382]
[null,"Wendy","Scanner",4573]
[null,"Gary","Headset",3728]
[null,"Claire","Scanner",5384]
[null,"Drew","Printer",8523]

{"sheet":"FileExt","index":6,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract File Extension Using Delimiter"]
[]
[null,"File Name","Extension"]
[null,"How to Split Strings.xlsm","xlsm"]
[null,"Sample Dataset.jpg","jpg"]
[null,"Split Strings Result.mp4","mp4"]
[null,"Extract File Extension.gif","gif"]

{"sheet":"State","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Get State Names from Address"]
[]
[null,"Address","State"]
[]
[null,"2362 Orphan Road, Mountain Lake, Minnesota, 56159",{"$f":"StateName(B6,3)","v":" Minnesota"}]
[null,"4916 Court Street, Fairview Heights, Missouri, 62208",{"$f":"StateName(B7,3)","v":" Missouri"}]
[null,"2696 Jail Drive, Los Angeles, California, 90017",{"$f":"StateName(B8,3)","v":" California"}]

{"sheet":"Multiple","index":8,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"VBA Split Multiple Delimiters"]
[]
[null,"Street No.","Street Name","City","State","Zip Code"]
[null,2362,"Orphan Road"," Mountain Lake"," Minnesota",56159]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yourself"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Never"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Look"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back"]