{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Set","Combination of LEN, TRIM & SUBS","Manual","VBA Macro"],"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":"Data Set","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Dataset"]
[]
[null,"Fruit List","Count"]
[null,"Banana, Grape, Apple, Orange"]
[null,"Lemon, Peach, Cherry, Pear"]
[null,"Mango, Plum, Avocado "]

{"sheet":"Combination of LEN, TRIM & SUBS","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Combination of LEN, TRIM & SUBSTITITE Functions",null,null,"Practice"]
[]
[null,"Fruit List","Count",null,"Fruit List","Count"]
[null,"Banana, Grape, Apple, Orange",{"$f":"LEN(TRIM(B5))-LEN(SUBSTITUTE(TRIM(B5),\",\",\"\"))+1","v":4},null,null,{"$f":"LEN(TRIM(E5))-LEN(SUBSTITUTE(TRIM(E5),\",\",\"\"))+1","v":1}]
[null,"Lemon, Peach, Cherry, Pear",{"$f":"LEN(TRIM(B6))-LEN(SUBSTITUTE(TRIM(B6),\",\",\"\"))+1","v":4},null,null,{"$f":"LEN(TRIM(E6))-LEN(SUBSTITUTE(TRIM(E6),\",\",\"\"))+1","v":1}]
[null,"Mango, Plum, Avocado ",3,null,null,1]

{"sheet":"Manual","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Manually Count Words"]
[]
[null,"Fruit List","Count"]
[null,"Banana, Grape, Apple, Orange",4]
[null,"Lemon, Peach, Cherry, Pear",4]
[null,"Mango, Plum, Avocado ",3]

{"sheet":"VBA Macro","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Use of VBA Macro",null,null,null,null,null,"Practice"]
[]
[null,"Fruit List",null,"Package No.","Fruits","Count",null,"Fruit List",null,"Package No.","Fruits","Count"]
[null,"Banana ",null,1,"Banana, Grape, Apple, Orange",{"$f":"Count_Words(E5,$B$5:$B$14)","v":4},null,null,null,1,null,{"$f":"Count_Words(K5,$B$5:$B$14)","v":0}]
[null,"Lemon",null,2,"Lemon, Peach, Cherry, Pear",{"$f":"Count_Words(E6,$B$5:$B$14)","v":3},null,null,null,2,null,{"$f":"Count_Words(K6,$B$5:$B$14)","v":0}]
[null,"Plum",null,3,"Mango, Plum, Avocado ",{"$f":"Count_Words(E7,$B$5:$B$14)","v":3},null,null,null,3,null,{"$f":"Count_Words(K7,$B$5:$B$14)","v":0}]
[null,"Grape"]
[null,"Apple"]
[null,"Orange"]
[null,"Peach"]
[null,"Avocado"]
[null,"Mango"]
[null,"Cherry"]