{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Uppercase","Lowercase","Upper-Lower","Number","Except Numbers","VBA"],"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":"Uppercase","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Counting Uppercase Characters",null,null,null,null,"Try Yourself"]
[]
[null,"Text","Character","Count",null,null,"Text","Character","Count"]
[null,"Hello Everyone","E",{"$f":"LEN(B5)-LEN(SUBSTITUTE(B5,C5,\"\"))","v":1},null,null,"Hello Everyone","E"]
[null,"Is It Imaginable?","I",{"$f":"LEN(B6)-LEN(SUBSTITUTE(B6,C6,\"\"))","v":3},null,null,"Is It Imaginable?","I"]
[null,"Call the Ambulance","C",1,null,null,"Call the Ambulance","C"]

{"sheet":"Lowercase","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Counting Lowercase Characters",null,null,null,null,"Try Yourself"]
[]
[null,"Text","Character","Count",null,null,"Text","Character","Count"]
[null,"Hello Everyone","e",{"$f":"LEN(B5)-LEN(SUBSTITUTE(B5,C5,\"\"))","v":3},null,null,"Hello Everyone","e"]
[null,"Is It Imaginable?","i",{"$f":"LEN(B6)-LEN(SUBSTITUTE(B6,C6,\"\"))","v":1},null,null,"Is It Imaginable?","i"]
[null,"Call the Ambulance","c",{"$f":"LEN(B7)-LEN(SUBSTITUTE(B7,C7,\"\"))","v":1},null,null,"Call the Ambulance","c"]

{"sheet":"Upper-Lower","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Both Upper and Lowercase Characters",null,null,null,null,"Try Yourself"]
[]
[null,"Text","Character","Count",null,null,"Text","Character","Count"]
[null,"Hello Everyone","e",{"$f":"LEN(B5)-LEN(SUBSTITUTE(LOWER(B5),LOWER(C5),\"\"))","v":4},null,null,"Hello Everyone","e"]
[null,"Is It Imaginable?","i",{"$f":"LEN(B6)-LEN(SUBSTITUTE(LOWER(B6),LOWER(C6),\"\"))","v":4},null,null,"Is It Imaginable?","i"]
[null,"Call the Ambulance","c",2,null,null,"Call the Ambulance","c"]

{"sheet":"Number","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Counting Numbers",null,null,null,null,"Try Yourself"]
[]
[null,"Email","Password","Count",null,null,"Email","Password","Count"]
[null,"catherine23@gmail.com","a3dbg56u8",{"$f":"SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":4},null,null,"catherine23@gmail.com","a3dbg56u8"]
[null,"mikejordan@gmail.com","hdf74ksa9",{"$f":"SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":3},null,null,"mikejordan@gmail.com","hdf74ksa9"]
[null,"davidhopper21@gmail.com","eert756h",{"$f":"SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":3},null,null,"davidhopper21@gmail.com","eert756h"]
[null,"sturat35@gmail.com","str45il",{"$f":"SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":2},null,null,"sturat35@gmail.com","str45il"]
[null,"jonathonharker@gmail.com","jonathon333",{"$f":"SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{0,1,2,3,4,5,6,7,8,9},\"\")))","v":3},null,null,"jonathonharker@gmail.com","jonathon333"]

{"sheet":"Except Numbers","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Counting Characters Except for Numbers",null,null,null,null,"Try Yourself"]
[]
[null,"Email","Password","Count",null,null,"Email","Password","Count"]
[null,"catherine23@gmail.com","a3dbg56u8",{"$f":"LEN(C5)-(SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":5},null,null,"catherine23@gmail.com","a3dbg56u8"]
[null,"mikejordan@gmail.com","hdf74ksa9",{"$f":"LEN(C6)-(SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":6},null,null,"mikejordan@gmail.com","hdf74ksa9"]
[null,"davidhopper21@gmail.com","eert756h",{"$f":"LEN(C7)-(SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":5},null,null,"davidhopper21@gmail.com","eert756h"]
[null,"sturat35@gmail.com","str45il",{"$f":"LEN(C8)-(SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":5},null,null,"sturat35@gmail.com","str45il"]
[null,"jonathonharker@gmail.com","jonathon333",{"$f":"LEN(C9)-(SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{0,1,2,3,4,5,6,7,8,9},\"\"))))","v":8},null,null,"jonathonharker@gmail.com","jonathon333"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Using VBA Code",null,null,null,null,"Try Yourself"]
[]
[null,"Email","Password","Count",null,null,"Email","Password","Count"]
[null,"catherine23@gmail.com","a3dbg56u8",{"$f":"CharacterNo(C5)","v":"1L1N3L2N1L1N"},null,null,"catherine23@gmail.com","a3dbg56u8"]
[null,"mikejordan@gmail.com","hdf74ksa9",{"$f":"CharacterNo(C6)","v":"3L2N3L1N"},null,null,"mikejordan@gmail.com","hdf74ksa9"]
[null,"davidhopper21@gmail.com","eert756h",{"$f":"CharacterNo(C7)","v":"4L3N1L"},null,null,"davidhopper21@gmail.com","eert756h"]
[null,"sturat35@gmail.com","str45il",{"$f":"CharacterNo(C8)","v":"3L2N2L"},null,null,"sturat35@gmail.com","str45il"]
[null,"jonathonharker@gmail.com","jonathon333",{"$f":"CharacterNo(C9)","v":"8L3N"},null,null,"jonathonharker@gmail.com","jonathon333"]