Use `=LEN(A1)` to count all characters in cell A1
Use `=LEN(TRIM(A1))` to count characters without leading, trailing, and extra spaces
Use `=LEN(SUBSTITUTE(A1,” “,””))` to count characters excluding spaces
Use `=LEN(A1)-LEN(SUBSTITUTE(A1,”a”,””))` to count how many times a specific character appears
Use `=SUMPRODUCT(LEN(A1:A10))` to count total characters across a range
Use `=COUNTA(A1:A10)` to count non-empty cells, not characters
Use `=LENB(A1)` for byte count in some language versions of Excel
