{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Overview","Dataset","LEN Function","multiple functions","VBA to Count Number","Sheet7","Sheet2","Sheet1","all characters","Characters without Numbers","Count Letters Using VBA","No. of Cells with Numbers","Counting Cells","Sheet3"],"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":"Overview","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting Numbers in a Cell"]
[]
[null,"Employee Name","Yearly Salary","Numbers in Cells"]
[null,"Mike",10000,{"$f":"LEN(C5)","v":5},">> =LEN(C5)"]
[null,"Steve",6000,{"$f":"LEN(C6)","v":4}]
[null,"Andrew",100000,6]
[null,"Amy",200000,6]
[null,"Jessica",12000,5]
[null,"Sara",300000,6]
[null,"Ross",43000,5]
[null,"Joe",1000000,7]
[null,"Louis",39000,5]
[null,"Hank",510000,6]

{"sheet":"Dataset","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Numbers in a Cell"]
[]
[null,"Employee Name","Yearly Salary"]
[null,"Mike",10000]
[null,"Steve",6000]
[null,"Andrew",100000]
[null,"Amy",200000]
[null,"Jessica",12000]
[null,"Sara",300000]
[null,"Ross",43000]
[null,"Joe",33000]
[null,"Louis",39000]
[null,"Hank",510000]

{"sheet":"LEN Function","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using LEN Function"]
[]
[null,"Employee Name","Yearly Salary","Numbers in Cells"]
[null,"Mike",10000,{"$f":"LEN(C5)","v":5}]
[null,"Steve",6000,{"$f":"LEN(C6)","v":4}]
[null,"Andrew",100000,6]
[null,"Amy",200000,6]
[null,"Jessica",12000,5]
[null,"Sara",300000,6]
[null,"Ross",43000,5]
[null,"Joe",33000,5]
[null,"Louis",39000,5]
[null,"Hank",510000,6]

{"sheet":"multiple functions","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining SUM, LEN and SUBSTITUTE Functions"]
[]
[null,"Employee Name","Pass Code","Numbers in Cells"]
[null,"Mike","aa203",{"$f":"SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]
[null,"Steve","be45",{"$f":"SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{1,2,3,4,5,6,7,8,9,0},)))","v":2}]
[null,"Andrew","cet657",{"$f":"SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]
[null,"Amy","89777uh",{"$f":"SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{1,2,3,4,5,6,7,8,9,0},)))","v":5}]
[null,"Jessica","897hgt",{"$f":"SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]
[null,"Sara","99kj8",{"$f":"SUM(LEN(C10)-LEN(SUBSTITUTE(C10,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]
[null,"Ross","hjd712000p",{"$f":"SUM(LEN(C11)-LEN(SUBSTITUTE(C11,{1,2,3,4,5,6,7,8,9,0},)))","v":6}]
[null,"Joe","mm801",{"$f":"SUM(LEN(C12)-LEN(SUBSTITUTE(C12,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]
[null,"Louis","0987hj",{"$f":"SUM(LEN(C13)-LEN(SUBSTITUTE(C13,{1,2,3,4,5,6,7,8,9,0},)))","v":4}]
[null,"Hank","nd78ol0",{"$f":"SUM(LEN(C14)-LEN(SUBSTITUTE(C14,{1,2,3,4,5,6,7,8,9,0},)))","v":3}]

{"sheet":"VBA to Count Number","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code to Count Numbers in a Cell"]
[]
[null,"Employee Name","Pass Code","Numbers in Cell "]
[null,"Mike","aa203",{"$f":"count_numbers_in_cell(C5)","v":"3N"}]
[null,"Steve","be45",{"$f":"count_numbers_in_cell(C6)","v":"2N"}]
[null,"Andrew","cet657",{"$f":"count_numbers_in_cell(C7)","v":"3N"}]
[null,"Amy","89777uh",{"$f":"count_numbers_in_cell(C8)","v":"5N"}]
[null,"Jessica","897hgt",{"$f":"count_numbers_in_cell(C9)","v":"3N"}]
[null,"Sara","998kj",{"$f":"count_numbers_in_cell(C10)","v":"3N"}]
[null,"Ross","hjd712000p",{"$f":"count_numbers_in_cell(C11)","v":"6N"}]
[null,"Joe","mm801",{"$f":"count_numbers_in_cell(C12)","v":"3N"}]
[null,"Louis","0987hj",{"$f":"count_numbers_in_cell(C13)","v":"4N"}]
[null,"Hank","njh78900",{"$f":"count_numbers_in_cell(C14)","v":"5N"}]

{"sheet":"Sheet7","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Applying LEN, FORMULATEXT, and SUBSTITUTE Functions"]
[]
[null,"Employee","January ","February","March","April","Total","FormulaText","Numbers"]
[null,"Mike",1200,1300,1380,1400,{"$f":"C5+D5+E5+F5","v":5280},{"$f":"_xlfn.FORMULATEXT(G5)","v":"=C5+D5+E5+F5"},{"$f":"LEN(_xlfn.FORMULATEXT(G5))-LEN(SUBSTITUTE(_xlfn.FORMULATEXT(G5),\"+\",\"\"))+1","v":4}]
[null,"Steve",1000,1200,1250,1300,{"$f":"C6+D6+E6+F6","v":4750},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=C6+D6+E6+F6"},{"$f":"LEN(_xlfn.FORMULATEXT(G6))-LEN(SUBSTITUTE(_xlfn.FORMULATEXT(G6),\"+\",\"\"))+1","v":4}]
[null,"Andrew",900,1000,1300,1380,4580,"=C7+D7+E7+F7",4]
[null,"Sara",850,1200,1600,1620,5270,"=C8+D8+E8+F8",4]
[null,"Lilly",1400,1450,1500,1600,5950,"=C9+D9+E9+F9",4]

{"sheet":"Sheet2","index":6,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Using VBA to Find Numbers in a Formula"]
[]
[null,"Employee ","January ","February","March","April","Total","FormulaText","Numbers"]
[null,"Mike",1200,1300,1380,1400,{"$f":"C5+D5+E5+F5","v":5280},{"$f":"_xlfn.FORMULATEXT(G5)","v":"=C5+D5+E5+F5"},{"$f":"count_numbers_in_formula(G5)","v":4}]
[null,"Steve",null,1200,1250,1300,{"$f":"D6+E6+F6","v":3750},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=D6+E6+F6"},{"$f":"count_numbers_in_formula(G6)","v":3}]
[null,"Andrew",null,1000,1300,null,{"$f":"D7+E7","v":2300},"=D7+E7",{"$f":"count_numbers_in_formula(G7)","v":2}]
[null,"Sara",850,null,null,null,{"$f":"C8","v":850},"=C8",{"$f":"count_numbers_in_formula(G8)","v":1}]

{"sheet":"Sheet1","index":7,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using VBA to Find Numbers in a Formula"]
[]
[null,"Employee ","January ","February","March","April","Total"]
[null,"Mike",1200,1300,1380,1400,{"$f":"C5+D5+E5+F5","v":5280}]
[null,"Steve",1000,1200,1250,1300,{"$f":"C6+D6+E6+F6","v":4750}]
[null,"Andrew",900,1000,1300,1380,4580]
[null,"Sara",850,1200,1600,1620,5270]
[null,"Lilly",1400,1450,1500,1600,5950]

{"sheet":"all characters","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting All Characters"]
[]
[null,"Employee Name","Pass Code","Characters in a Cell"]
[null,"Mike","aa203#",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"))","v":3}]
[null,"Steve","be45",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"))","v":2}]
[null,"Andrew","cet657",3]
[null,"Amy","89777uh",2]
[null,"Jessica","897hgt",3]
[null,"Sara","99kj8",2]
[null,"Ross","hjd712000p*",5]
[null,"Joe","mm801",2]
[null,"Louis","0987hj",2]
[null,"Hank","nd78ol0",4]

{"sheet":"Characters without Numbers","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting Characters Excluding Number in a Cell"]
[]
[null,"Employee Name","Pass Code","Non-Numeric Characters in a Cell"]
[null,"Mike","1gh213aa",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C5,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"))","v":4}]
[null,"Steve","be45gg",{"$f":"LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C6,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"))","v":4}]
[null,"Andrew","cet657",3]
[null,"Amy","89777uh",2]
[null,"Jessica","897hgt",3]
[null,"Sara","9jh98kj",4]
[null,"Ross","hjd712000",3]
[null,"Joe","mm801",2]
[null,"Louis","f09g87hj",4]
[null,"Hank","njh78900",3]

{"sheet":"Count Letters Using VBA","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA Code to Count Non-Numeric Characters"]
[]
[null,"Employee Name","Pass Code","Non-Numeric Characters in a Cell"]
[null,"Mike","aa203",{"$f":"count_Non_Numeric_Characters(C5)","v":"2L"}]
[null,"Steve","be45",{"$f":"count_Non_Numeric_Characters(C6)","v":"2L"}]
[null,"Andrew","cet657",{"$f":"count_Non_Numeric_Characters(C7)","v":"3L"}]
[null,"Amy","89777uh",{"$f":"count_Non_Numeric_Characters(C8)","v":"2L"}]
[null,"Jessica","897hgt",{"$f":"count_Non_Numeric_Characters(C9)","v":"3L"}]
[null,"Sara","998kj",{"$f":"count_Non_Numeric_Characters(C10)","v":"2L"}]
[null,"Ross","hjd712000",{"$f":"count_Non_Numeric_Characters(C11)","v":"3L"}]
[null,"Joe","mm801",{"$f":"count_Non_Numeric_Characters(C12)","v":"2L"}]
[null,"Louis","0987hj",{"$f":"count_Non_Numeric_Characters(C13)","v":"2L"}]
[null,"Hank","njh78900",{"$f":"count_Non_Numeric_Characters(C14)","v":"3L"}]

{"sheet":"No. of Cells with Numbers","index":11,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Cells with Numbers in a Dataset"]
[]
[null,"Employee Name","Pass Code"]
[null,"Mike","102p"]
[null,"Steve",2344]
[null,"Andrew","j67b"]
[null,"Amy",8976]
[null,"Jessica",91]
[null,"Sara","jhuyg"]
[null,"Ross",123]
[null,"Joe",6542]
[null,"Louis","bcjd"]
[null,"Hank","kjk90"]
[]
[null,"No. of Cells Containing Numbers ",{"$f":"COUNT(B5:C14)","v":5}]

{"sheet":"Counting Cells","index":12,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[null,"Counting Cells in a Dataset"]
[]
[null,"Employee Name","Designation","Pass Code","Salary"]
[null,"Mike","Engineer","aa203*",10000]
[null,"Steve","Marketing Manager","be*45"]
[null,"Andrew","Financial Analyst","cet657",100000]
[null,"Amy","Engineer",null,8000]
[null,"Jessica",null,"897hgt",12000]
[null,"Sara","Engineer","998kj",12000]
[null,"Ross","Data Scientist","hjd712000p",43000]
[null,"Joe","Operations Manager","mm801"]
[null,"Louis",null,null,39000]
[null,"Hank","Engineer","njh78900",10000]
[]
[null,"Number of Nonempty Cells (COUNT Function)",null,null,{"$f":"COUNTA(B5:E14)","v":34}]
[null,"Number of Empty Cells (COUNTBLANK Function)",null,null,{"$f":"COUNTBLANK(B5:E14)","v":6}]
[null,"Count of Cells Containing \"Engineer\" (COUNTIF Function)",null,null,{"$f":"COUNTIF(C5:C14,\"Engineer\")","v":4}]
[null,"Count of Cells Containing \"Engineer\" & \"$10,000\" (COUNTIFS Function)",null,null,{"$f":"COUNTIFS(C5:C14,\"Engineer\",E5:E14,\"=\"& \"10,000\")","v":2}]

{"sheet":"Sheet3","index":13,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Total Characters"]
[]
[null,"Employee Name","Pass Code"]
[null,"Mike","1gh213aa"]
[null,"Steve","be45gg"]
[null,"Andrew","cet657"]
[null,"Amy","89777uh"]
[null,"Jessica","897hgt"]
[null,"Sara","9jh98kj"]
[null,"Ross","hjd712000"]
[null,"Joe","mm801"]
[null,"Louis","f09g87hj"]
[null,"Hank","njh78900"]
[]
[null,"Total Characters in a Range of Cells",{"$f":"SUMPRODUCT(LEN(B5:C14))","v":115}]