{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Set","1. Count Words in Cell","2. Range Words Count","3. Specific Word in Cell","4. Specific Word Count in Range","5. Count in Word","6. Custom Function"],"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Words in Excel"]
[]
[null,"Text String","No. of Words"]
[null,"Mary had a little lamb"]
[null,"Its fleece was white as snow, yeah"]
[null,"Everywhere the child went,"]
[null,"The little lamb was sure to go, yeah."]

{"sheet":"1. Count Words in Cell","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Counting Words in a Cell",null,null,null,"Practise Yourself"]
[]
[null,"Text String","No. of Words",null,null,"Text String","No. of Words"]
[null,"Mary had a little lamb",{"$f":"LEN(TRIM(B5))-LEN(SUBSTITUTE(B5,\" \",\"\"))+1","v":5},null,null,"Mary had a little lamb"]
[null,"Its fleece was white as snow, yeah",{"$f":"LEN(TRIM(B6))-LEN(SUBSTITUTE(B6,\" \",\"\"))+1","v":7},null,null,"Its fleece was white as snow, yeah"]
[null,"Everywhere the child went,",4,null,null,"Everywhere the child went,"]
[null,"The little lamb was sure to go, yeah.",8,null,null,"The little lamb was sure to go, yeah."]
[null,null,{"$f":"IF(B9=\"\",0,LEN(TRIM(B9))-LEN(SUBSTITUTE(B9,\" \",\"\"))+1)","v":0}]

{"sheet":"2. Range Words Count","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Counting Words in a Range",null,null,null,"Practise Yourself"]
[]
[null,"Text String","No. of Words",null,null,"Text String","No. of Words"]
[null,"Mary had a little lamb",{"$f":"IF(B5=\"\",0,LEN(TRIM(B5))-LEN(SUBSTITUTE(B5,\" \",\"\"))+1)","v":5},null,null,"Mary had a little lamb"]
[null,"Its fleece was white as snow, yeah",7,{"$f":"IF(B9=\"\",0,LEN(TRIM(B9))-LEN(SUBSTITUTE(B9,\" \",\"\"))+1)","v":0},null,"Its fleece was white as snow, yeah"]
[null,"Everywhere the child went,",4,null,null,"Everywhere the child went,"]
[null,"The little lamb was sure to go, yeah.",8,null,null,"The little lamb was sure to go, yeah."]
[null,null,{"$f":"IF(B9=\"\",0,LEN(TRIM(B9))-LEN(SUBSTITUTE(B9,\" \",\"\"))+1)","v":0}]
[null,"Total Words in the Range",{"$f":"SUM(IF(B5:B9=\"\",0,LEN(TRIM(B5:B9))-LEN(SUBSTITUTE(B5:B9,\" \",\"\"))+1))","v":24},null,null,"Total Words in the Range"]

{"sheet":"3. Specific Word in Cell","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Counting Specific Word in a Cell",null,null,"Practise Yourself"]
[]
[null,"Text String","No. of \"yeah\"",null,"Text String","No. of \"yeah\""]
[null,"Mary had a little lamb Its fleece was white as snow, yeah Everywhere the child went, The little lamb was sure to go, yeah.",{"$f":"(LEN(B5)-LEN(SUBSTITUTE(B5, \"yeah\",\"\")))/LEN(\"yeah\")","v":2},null,"Mary had a little lamb Its fleece was white as snow, yeah Everywhere the child went, The little lamb was sure to go, yeah."]

{"sheet":"4. Specific Word Count in Range","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Counting Words in a Range",null,null,null,null,"Practise Yourself"]
[]
[null,"Text String",null,"No. of \"Mary\"",null,null,"Text String",null,"No. of \"Mary\""]
[null,"Mary had a little lamb,",null,{"$f":"SUM((LEN(B5:B20)-LEN(SUBSTITUTE(UPPER(B5:B20), UPPER(\"Mary\"),\"\")))/LEN(\"Mary\"))","v":5},null,null,"Mary had a little lamb,",null,{"$f":"SUM((LEN(G5:G20)-LEN(SUBSTITUTE(UPPER(G5:G20), UPPER(\"Mary\"),\"\")))/LEN(\"Mary\"))","v":5}]
[null,"Its fleece was white as snow;",null,null,null,null,"Its fleece was white as snow;"]
[null,"And everywhere that Mary went",null,null,null,null,"And everywhere that Mary went"]
[null,"The lamb was sure to go.",null,null,null,null,"The lamb was sure to go."]
[null,"It followed her to school one day,",null,null,null,null,"It followed her to school one day,"]
[null,"Which was against the rule;",null,null,null,null,"Which was against the rule;"]
[null,"It made the children laugh and play",null,null,null,null,"It made the children laugh and play"]
[null,"To see a lamb at school.",null,null,null,null,"To see a lamb at school."]
[null,"And so the teacher turned it out,",null,null,null,null,"And so the teacher turned it out,"]
[null,"But still it lingered near,",null,null,null,null,"But still it lingered near,"]
[null,"And waited patiently about",null,null,null,null,"And waited patiently about"]
[null,"Till Mary did appear.",null,null,null,null,"Till Mary did appear."]
[null,"Why does the lamb love Mary so?",null,null,null,null,"Why does the lamb love Mary so?"]
[null,"The eager children cry;",null,null,null,null,"The eager children cry;"]
[null,"Why, Mary loves the lamb, you know,",null,null,null,null,"Why, Mary loves the lamb, you know,"]
[null,"The teacher did reply.",null,null,null,null,"The teacher did reply."]

{"sheet":"5. Count in Word","index":5,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Microsoft Word"]
[]
[null,"Text String"]
[null,"Mary had a little lamb,"]
[null,"Its fleece was white as snow;"]
[null,"And everywhere that Mary went"]
[null,"The lamb was sure to go."]
[null,"It followed her to school one day,"]
[null,"Which was against the rule;"]
[null,"It made the children laugh and play"]
[null,"To see a lamb at school."]
[null,"And so the teacher turned it out,"]
[null,"But still it lingered near,"]
[null,"And waited patiently about"]
[null,"Till Mary did appear."]
[null,"Why does the lamb love Mary so?"]
[null,"The eager children cry;"]
[null,"Why, Mary loves the lamb, you know,"]
[null,"The teacher did reply."]

{"sheet":"6. Custom Function","index":6,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Custom Function",null,null,null,null,"Practise Yourself"]
[]
[null,"Text String","Total Words in the Range",null,null,null,"Text String","Total Words in the Range"]
[null,"Mary had a little lamb,",{"$f":"WORD_COUNT(B5:B23)","v":89},null,null,null,"Mary had a little lamb,"]
[null,"Its fleece was white as snow;",null,null,null,null,"Its fleece was white as snow;"]
[null,"And everywhere that Mary went",null,null,null,null,"And everywhere that Mary went"]
[null,"The lamb was sure to go.",null,null,null,null,"The lamb was sure to go."]
[null,"It followed her to school one day,",null,null,null,null,"It followed her to school one day,"]
[null,"Which was against the rule;",null,null,null,null,"Which was against the rule;"]
[null,"It made the children laugh and play",null,null,null,null,"It made the children laugh and play"]
[null,"To see a lamb at school.",null,null,null,null,"To see a lamb at school."]
[null,"And so the teacher turned it out,",null,null,null,null,"And so the teacher turned it out,"]
[null,"But still it lingered near,",null,null,null,null,"But still it lingered near,"]
[null,"And waited patiently about",null,null,null,null,"And waited patiently about"]
[null,"Till Mary did appear.",null,null,null,null,"Till Mary did appear."]
[null,"Why does the lamb love Mary so?",null,null,null,null,"Why does the lamb love Mary so?"]
[null,"The eager children cry;",null,null,null,null,"The eager children cry;"]
[null,"Why, Mary loves the lamb, you know,",null,null,null,null,"Why, Mary loves the lamb, you know,"]
[null,"The teacher did reply.",null,null,null,null,"The teacher did reply."]