{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Splitting Words from String","Words Separated with Delimeter","Dividing Address","Counting Words","Finding Specific Word","Changing Limit Parameter","Copying Data","Letter as Delimeter","Finding Extension","File name","Words with Multiple Delimeters","Join to Reverse Split"],"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":"Splitting Words from String","index":0,"n_rows":9,"n_cols":25,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,4],[3,24,3,27]]}
[]
[null,"Splitting Words from String"]
[]
[null,"We",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"We are learning VBA SPLIT Function."]
[null,"are"]
[null,"learning"]
[null,"VBA"]
[null,"SPLIT"]
[null,"Function."]

{"sheet":"Words Separated with Delimeter","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Words Separated with Delimiter"]
[]
[null,"Apples"]
[null,"Bananas"]
[null,"Oranges"]
[null,"Mangoes"]

{"sheet":"Dividing Address","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dividing Address into Multiple Parts"]
[]
[null,"Address","Address in Parts"]
[null,"221B, Baker Street, London, KY 40741",{"$f":"ThreePartAddress(B5)","v":"221B\r\nBaker Street\r\nLondon, KY 40741\r"}]
[null,"1 Microsoft Way, Redmond, Washington, 98052",{"$f":"ThreePartAddress(B6)","v":"1 Microsoft Way\r\nRedmond\r\nWashington, 98052\r"}]
[null,"790 SE 13th Pl, Warrenton, Virginia, 97146",{"$f":"ThreePartAddress(B7)","v":"790 SE 13th Pl\r\nWarrenton\r\nVirginia, 97146\r"}]
[null,"6673 Mia Ave, Riverside, California, 92503",{"$f":"ThreePartAddress(B8)","v":"6673 Mia Ave\r\nRiverside\r\nCalifornia, 92503\r"}]
[null,"1107 SE 23rd Pl, Cape Coral, Florida, 33990",{"$f":"ThreePartAddress(B9)","v":"1107 SE 23rd Pl\r\nCape Coral\r\nFlorida, 33990\r"}]

{"sheet":"Counting Words","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Words from String"]
[]
[null,"String","Words"]
[null,"Whoever is happy will make others happy too",{"$f":"WordCount(B5)","v":8}]
[null,"You become what you believe",{"$f":"WordCount(B6)","v":5}]
[null,"Dream big and dare to fail",{"$f":"WordCount(B7)","v":6}]
[null,"One man with courage makes a majority",{"$f":"WordCount(B8)","v":7}]
[null,"Worry is a misuse of imagination",{"$f":"WordCount(B9)","v":6}]

{"sheet":"Finding Specific Word","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Finding Specific Word from a String"]
[]
[null,"Address","City"]
[null,"221B, Baker Street, London, KY 40741",{"$f":"FindSpecificWord(B5,3)","v":" London"}]
[null,"1 Microsoft Way, Redmond, Washington, 98052",{"$f":"FindSpecificWord(B6,3)","v":" Washington"}]
[null,"790 SE 13th Pl, Warrenton, Virginia, 97146",{"$f":"FindSpecificWord(B7,3)","v":" Virginia"}]
[null,"6673 Mia Ave, Riverside, California, 92503",{"$f":"FindSpecificWord(B8,3)","v":" California"}]
[null,"1107 SE 23rd Pl, Cape Coral, Florida, 33990",{"$f":"FindSpecificWord(B9,3)","v":" Florida"}]

{"sheet":"Changing Limit Parameter","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Changing Limit Parameter"]
[]
[null,"Apples, Bananas, Oranges, Mangoes"]

{"sheet":"Copying Data","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Data Using VBA SPLIT Function"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Analyst II","Sales"]
[null,"E02968","Caroline Santos","Analyst II","Finance"]
[null,"E03362","Lily Henderson","HRIS Analyst","Human Resources"]
[null,"E01108","Hannah Martinez","Manager","Marketing"]
[null,"E02217","William Phillips","Network Architect","IT"]
[null,"E03519","Eliza Zheng","Computer Systems Manager","IT"]

{"sheet":"Letter as Delimeter","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Letter as Delimiter in VBA SPLIT Function"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,3611,"Alice Mehta","Analyst II","Sales"]
[null,4464,"Caroline Santos","Analyst II","Finance"]
[null,2135,"Lily Henderson","HRIS Analyst","Human Resources"]
[null,1684,"Hannah Martinez","Manager","Marketing"]
[null,2968,"William Phillips","Network Architect","IT"]
[null,3362,"Eliza Zheng","Computer Systems Manager","IT"]

{"sheet":"Finding Extension","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding an Extension Using SPLIT Function"]
[]
[null,"ID","Email Address","First Term of Email","Extension"]
[null,"E03611","Landon25@gmail.com","Landon25","gmail.com"]
[null,"E04464","Hadley2012@gmail.com","Hadley2012","gmail.com"]
[null,"E02135","Austin@outlook.com","Austin","outlook.com"]
[null,"E01684","isabella.bailey@outlook.com","isabella.bailey","outlook.com"]
[null,"Liang","huynh.1997@yahoo.com ","huynh.1997","yahoo.com "]
[null,"E03362","hadley-yee@outlook.com","hadley-yee","outlook.com"]
[null,"E01108","julia10@gmail.com","julia10","gmail.com"]
[null,"E02217","christian.fong@hotmail.com","christian.fong","hotmail.com"]
[null,"E03519","hazel@yahoo.com","hazel","yahoo.com"]

{"sheet":"File name","index":9,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding File Names and Extensions Using SPLIT Function"]
[]
[null,"ID","File Name with Extension","File Name","Extension"]
[null,"E03611","My Resume.pdf","My Resume","pdf"]
[null,"E04464","Work Instructions.pdf","Work Instructions","pdf"]
[null,"E02135","Excel Data.xlsx","Excel Data","xlsx"]

{"sheet":"Words with Multiple Delimeters","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Splitting Words with Multiple Delimiters"]
[]
[null,"ID","Full Name","Job Title","Department"]
[null,"E03611","Alice Mehta","Alice Mehta","Alice Mehta"]
[null,"E02968","Caroline Santos","Caroline Santos","Caroline Santos"]
[null,"E03362","Lily Henderson","Lily Henderson","Lily Henderson"]
[null,"E01108","Hannah Martinez","Hannah Martinez","Hannah Martinez"]
[null,"E02217","William Phillips","William Phillips","William Phillips"]
[null,"E03519","Eliza Zheng","Computer Systems Manager","IT"]

{"sheet":"Join to Reverse Split","index":11,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using JOIN Function to Reverse Split"]
[]
[null,"We,are,learning,reverse,split,in,Excel"]
[]
[null,"We are learning reverse split in Excel"]