{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LEN & SUBSTITUTE Functions","UPPER & SUBSTITUTE Functions ","LOWER & SUBSTITUTE Functions","SUMPRODUCT, LEN & SUBSTITUTE Fu","Using VBA_x0009_"],"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":"LEN & SUBSTITUTE Functions","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of LEN & SUBSTITUTE Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"SL NO","PRODUCT","COUNT \"C\"",null,null,null,null,"SL NO","PRODUCT","COUNT \"C\""]
[null,1,"C44, A44, C99, c44, M44",{"$f":"LEN(C5)-LEN(SUBSTITUTE(C5,\"C\",\"\"))","v":2},null,null,null,null,1,"C44, A44, C99, c44, M44"]
[null,2,"D55, N55, c55, M55, C55",{"$f":"LEN(C6)-LEN(SUBSTITUTE(C6,\"C\",\"\"))","v":1},null,null,null,null,2,"D55, N55, c55, M55, C55"]
[null,3,"E33, A33, C33, A66, N66",1,null,null,null,null,3,"E33, A33, C33, A66, N66"]
[null,4,"M88, c88, C88, A88, C88",2,null,null,null,null,4,"M88, c88, C88, A88, C88"]

{"sheet":"UPPER & SUBSTITUTE Functions ","index":1,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of UPPER & SUBSTITUTE Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"SL NO","PRODUCT","COUNT \"C\"",null,null,null,null,"SL NO","PRODUCT","COUNT \"C\""]
[null,1,"C44, A44, C99, c44, M44",{"$f":"LEN(C5)-LEN(SUBSTITUTE(UPPER(C5),\"C\",\"\"))","v":3},null,null,null,null,1,"C44, A44, C99, c44, M44"]
[null,2,"D55, N55, c55, M55, C55",{"$f":"LEN(C6)-LEN(SUBSTITUTE(UPPER(C6),\"C\",\"\"))","v":2},null,null,null,null,2,"D55, N55, c55, M55, C55"]
[null,3,"E33, A33, C33, A66, N66",1,null,null,null,null,3,"E33, A33, C33, A66, N66"]
[null,4,"M88, c88, C88, A88, C88",3,null,null,null,null,4,"M88, c88, C88, A88, C88"]

{"sheet":"LOWER & SUBSTITUTE Functions","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of LOWER & SUBSTITUTE Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"SL NO","PRODUCT","COUNT \"c\"",null,null,null,null,"SL NO","PRODUCT","COUNT \"c\""]
[null,1,"C44, A44, C99, c44, M44",{"$f":"LEN(C5)-LEN(SUBSTITUTE(LOWER(C5),\"c\",\"\"))","v":3},null,null,null,null,1,"C44, A44, C99, c44, M44"]
[null,2,"D55, N55, c55, M55, C55",{"$f":"LEN(C6)-LEN(SUBSTITUTE(LOWER(C6),\"c\",\"\"))","v":2},null,null,null,null,2,"D55, N55, c55, M55, C55"]
[null,3,"E33, A33, C33, A66, N66",1,null,null,null,null,3,"E33, A33, C33, A66, N66"]
[null,4,"M88, c88, C88, A88, C88",3,null,null,null,null,4,"M88, c88, C88, A88, C88"]

{"sheet":"SUMPRODUCT, LEN & SUBSTITUTE Fu","index":3,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Use of SUMPRODUCT, LEN & SUBSTITUTE Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"SL NO","PRODUCT",null,"Total COUNT \"C\"",null,null,null,"SL NO","PRODUCT",null,"Total COUNT \"C\""]
[null,1,"C44, A44, C99, c44, M44",null,{"$f":"SUMPRODUCT(LEN(C5:C8)-LEN(SUBSTITUTE(C5:C8,\"C\",\"\")))","v":6},null,null,null,1,"C44, A44, C99, c44, M44"]
[null,2,"D55, N55, c55, M55, C55",null,null,null,null,null,2,"D55, N55, c55, M55, C55"]
[null,3,"E33, A33, C33, A66, N66",null,null,null,null,null,3,"E33, A33, C33, A66, N66"]
[null,4,"M88, c88, C88, A88, C88",null,null,null,null,null,4,"M88, c88, C88, A88, C88"]

{"sheet":"Using VBA_x0009_","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA"]
[]
[null,"SL NO","PRODUCT"]
[null,1,"C44, A44, C99, c44, M44"]
[null,2,"D55, N55, c55, M55, C55"]
[null,3,"E33, A33, C33, A66, N66"]
[null,4,"M88, c88, C88, A88, C88"]