{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","TextColumns","Power","Table5","MiscFunc","VBA","Flash_Fill"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Split Data into Columns by Comma"]
[]
[null,"Fruits"]
[null,"Dates, Grapes, Watermelon"]
[null,"Rockmelon, Coconut, Mango"]
[null,"Apple, Orange, Pears"]
[null,"Kiwi, Olive, Cherries"]
[null,"Grapefruit, Banana, Papaya"]
[null,"Pineapple, Mandarin, Blueberry"]

{"sheet":"TextColumns","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of 'Text to Columns' Feature",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits",null,null,null,null,null,null,null,null,null,"Fruits"]
[null,"Dates, Grapes, Watermelon","Dates"," Grapes"," Watermelon",null,null,null,null,null,null,"Dates, Grapes, Watermelon"]
[null,"Rockmelon, Coconut, Mango","Rockmelon"," Coconut"," Mango",null,null,null,null,null,null,"Rockmelon, Coconut, Mango"]
[null,"Apple, Orange, Pears","Apple"," Orange"," Pears",null,null,null,null,null,null,"Apple, Orange, Pears"]
[null,"Kiwi, Olive, Cherries","Kiwi"," Olive"," Cherries",null,null,null,null,null,null,"Kiwi, Olive, Cherries"]
[null,"Grapefruit, Banana, Papaya","Grapefruit"," Banana"," Papaya",null,null,null,null,null,null,"Grapefruit, Banana, Papaya"]
[null,"Pineapple, Mandarin, Blueberry","Pineapple"," Mandarin"," Blueberry",null,null,null,null,null,null,"Pineapple, Mandarin, Blueberry"]

{"sheet":"Power","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruit",null,null,null,null,null,null,null,null,null,"Fruits"]
[null,"Dates, Grapes, Watermelon",null,null,null,null,null,null,null,null,null,"Dates, Grapes, Watermelon"]
[null,"Rockmelon, Coconut, Mango",null,null,null,null,null,null,null,null,null,"Rockmelon, Coconut, Mango"]
[null,"Apple, Orange, Pears",null,null,null,null,null,null,null,null,null,"Apple, Orange, Pears"]
[null,"Kiwi, Olive, Cherries",null,null,null,null,null,null,null,null,null,"Kiwi, Olive, Cherries"]
[null,"Grapefruit, Banana, Papaya",null,null,null,null,null,null,null,null,null,"Grapefruit, Banana, Papaya"]
[null,"Pineapple, Mandarin, Blueberry",null,null,null,null,null,null,null,null,null,"Pineapple, Mandarin, Blueberry"]

{"sheet":"Table5","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Fruit.1","Fruit.2","Fruit.3"]
["Dates"," Grapes"," Watermelon"]
["Rockmelon"," Coconut"," Mango"]
["Apple"," Orange"," Pears"]
["Kiwi"," Olive"," Cherries"]
["Grapefruit"," Banana"," Papaya"]
["Pineapple"," Mandarin"," Blueberry"]

{"sheet":"MiscFunc","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LEFT, RIGHT, MID, FIND & LEN Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits","1st Word","2nd Word","3rd Word",null,null,null,null,null,null,"Fruits"]
[null,"Dates, Grapes, Watermelon",{"$f":"LEFT(B5,FIND(\",\", B5)-1)","v":"Dates"},{"$f":"MID(B5,FIND(\",\",B5)+1,FIND(\",\",B5,FIND(\",\",B5)+1)-FIND(\",\",B5)-1)","v":" Grapes"},{"$f":"RIGHT(B5, LEN(B5)-FIND(\",\", B5,FIND(\",\",B5)+1))","v":" Watermelon"},null,null,null,null,null,null,"Dates, Grapes, Watermelon"]
[null,"Rockmelon, Coconut, Mango",{"$f":" LEFT(B6,FIND(\",\", B6)-1)","v":"Rockmelon"},{"$f":"MID(B6,FIND(\",\",B6)+1,FIND(\",\",B6,FIND(\",\",B6)+1)-FIND(\",\",B6)-1)","v":" Coconut"},{"$f":"RIGHT(B6, LEN(B6)-FIND(\",\", B6,FIND(\",\",B6)+1))","v":" Mango"},null,null,null,null,null,null,"Rockmelon, Coconut, Mango"]
[null,"Apple, Orange, Pears","Apple"," Orange"," Pears",null,null,null,null,null,null,"Apple, Orange, Pears"]
[null,"Kiwi, Olive, Cherries","Kiwi"," Olive"," Cherries",null,null,null,null,null,null,"Kiwi, Olive, Cherries"]
[null,"Grapefruit, Banana, Papaya","Grapefruit"," Banana"," Papaya",null,null,null,null,null,null,"Grapefruit, Banana, Papaya"]
[null,"Pineapple, Mandarin, Blueberry","Pineapple"," Mandarin"," Blueberry",null,null,null,null,null,null,"Pineapple, Mandarin, Blueberry"]

{"sheet":"VBA","index":5,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits",null,null,null,null,null,null,null,null,null,"Fruits"]
[null,"Dates, Grapes, Watermelon","Dates"," Grapes"," Watermelon",null,null,null,null,null,null,"Dates, Grapes, Watermelon"]
[null,"Rockmelon, Coconut, Mango","Rockmelon"," Coconut"," Mango",null,null,null,null,null,null,"Rockmelon, Coconut, Mango"]
[null,"Apple, Orange, Pears","Apple"," Orange"," Pears",null,null,null,null,null,null,"Apple, Orange, Pears"]
[null,"Kiwi, Olive, Cherries","Kiwi"," Olive"," Cherries",null,null,null,null,null,null,"Kiwi, Olive, Cherries"]
[null,"Grapefruit, Banana, Papaya","Grapefruit"," Banana"," Papaya",null,null,null,null,null,null,"Grapefruit, Banana, Papaya"]
[null,"Pineapple, Mandarin, Blueberry","Pineapple"," Mandarin"," Blueberry",null,null,null,null,null,null,"Pineapple, Mandarin, Blueberry"]

{"sheet":"Flash_Fill","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Flash Fill"]
[]
[null,"Fruits"]
[null,"Dates, Grapes, Watermelon","Dates"]
[null,"Rockmelon, Coconut, Mango","Rockmelon"]
[null,"Apple, Orange, Pears","Apple"]
[null,"Kiwi, Olive, Cherries","Kiwi"]
[null,"Grapefruit, Banana, Papaya","Grapefruit"]
[null,"Pineapple, Mandarin, Blueberry","Pineapple"]