{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Split into Substrings","Three Part Address","Word Count","Return Nth Value"],"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":"Split into Substrings","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["VBA SPLIT Function"]
[]
[null,"We"]
[null,"are"]
[null,"learning"]
[null,"VBA"]
[null,"SPLIT"]

{"sheet":"Three Part Address","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["VBA SPLIT Function"]
[]
[null,"Adress","Address in Parts"]
[null,"1107 SE 23rd Pl, Cape Coral, FL, 33990",{"$f":"ThreePartAddress(B4)","v":"1107 SE 23rd Pl\r\nCape Coral\r\nFL, 33990\r"}]
[null,"6673 Mia Ave, Riverside, CA, 92503",{"$f":"ThreePartAddress(B5)","v":"6673 Mia Ave\r\nRiverside\r\nCA, 92503\r"}]
[null,"567 S Benson Rd, Fairfield, CT, 06824","567 S Benson Rd\r\nFairfield\r\nCT, 06824\r"]
[null,"790 SE 13th Pl, Warrenton, OR, 97146 ","790 SE 13th Pl\r\nWarrenton\r\nOR, 97146\r"]
[null,"300 Gatewood Dr, Lansing, MI, 48917","300 Gatewood Dr\r\nLansing\r\nMI, 48917\r"]

{"sheet":"Word Count","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["VBA SPLIT Function"]
[]
[null,"Sentence","Words"]
[null,"The quick brown fox jumps over a lazy dog",{"$f":"WordCount(B4)","v":9}]
[null,"An apple a day keeps the doctor away",{"$f":"WordCount(B5)","v":8}]
[null,"Cleanliness is next to Godliness",5]
[null,"Don't judge a book by its cover",7]

{"sheet":"Return Nth Value","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["VBA SPLIT Function"]
[]
[null,"Adress","City Name"]
[null,"1107 SE 23rd Pl, Cape Coral, Florida, 33990",{"$f":"ReturnNthValue(B4,3)","v":" Florida"}]
[null,"6673 Mia Ave, Riverside, California, 92503",{"$f":"ReturnNthValue(B5,3)","v":" California"}]
[null,"567 S Benson Rd, Fairfield, Connecticut, 06824"," Connecticut"]
[null,"790 SE 13th Pl, Warrenton, Virginia, 97146 "," Virginia"]
[null,"300 Gatewood Dr, Lansing, Michigan, 48917"," Michigan"]