{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Len Function","Characters.Count","Occurances","Total","For Loop"],"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":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Excel VBA: Count Charactrers in Cell "]
[]
[null,"String/Number","No of Characters in Cell"]
[null,"Hello World!",null,{"$f":"SUMPRODUCT(LEN(B5:B8))","v":48}]
[null,"Good Morining",0]
[null,"123-568-487",11]
[null,"#fff - White"]
[]
[null,null,{"$f":"SUMPRODUCT(LEN(B5:B8))","v":48}]

{"sheet":"Len Function","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of the Len Function to Count Charactrers in Cell "]
[]
[null,"String/Number","No of Characters in Cell","Code"]
[null,"Hello World!",12,"Len(Range(\"B5\"))"]
[null,"Good Morining",13,"Len(Range(\"B6\"))"]
[null,"123-568-487",11,"Len(Range(\"B7\"))"]
[null,"#fff - White",12,"Len(Range(\"B8\"))"]
[null,null,0,"Len(Range(\"B9\"))"]

{"sheet":"Characters.Count","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of the Character.Count Property to Count Charactrers in Cell "]
[]
[null,"String/Number","No of Characters in Cell","Code"]
[null,"Hello World!",12,"Range(\"B5\").Characters.Count"]
[null,"Good Morining",13,"Range(\"B6\").Characters.Count"]
[null,"123-568-487",11,"Range(\"B7\").Characters.Count"]
[null,"#fff - White",12,"Range(\"B8\").Characters.Count"]
[null,null,0,"Range(\"B9\").Characters.Count"]

{"sheet":"Occurances","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,1,10,2],[1,1,1,3]]}
[]
[null,"Count No of Occurances of Characters in a Cell"]
[]
[null,"String/Number","No of Characters in Cell","Character Searched "]
[null,"1,2,3,4,5,6",5,","]
[null,"@John@Moris@Jim",3,"@"]
[null,"123-568-487",2,"-"]
[]
[]
[]
[null,"Code Explanation"]
[null,"Len(Range(\"B5\"))",11]
[null,"Replace(Range(\"B5\"), \",\", \"\", 1, -1, vbTextCompare)",123456]
[null,"Len(Replace(Range(\"B5\"), \",\", \"\", 1, -1, vbTextCompare))",6]
[null,"Len(Range(\"B5\")) - Len(Replace(Range(\"B5\"), \",\", \"\", 1, -1, vbTextCompare))",5]

{"sheet":"Total","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Total No of Charactrers in a Range of  Cells "]
[]
[null,"String/Number","No of Characters in Cell"]
[null,"Hello World!",12]
[null,"Good Morining",13]
[null,"123-568-487",11]
[null,"#fff - White",12]
[]
[null,"Total No of Characters:",{"$f":"SUMPRODUCT(LEN(B5:B8))","v":48}]

{"sheet":"For Loop","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Total No of Charactrers in a Range of  Cells "]
[]
[null,"String/Number","No of Characters in Cell"]
[null,"Hello World!",12]
[null,"Good Morining",13]
[null,"123-568-487",11]
[null,"#fff - White",12]
[]
[null,"Total No of Characters:",48]