View Single Post
  #7   Report Post  
Harlan Grove
 
Posts: n/a
Default

PCLIVE wrote...
Don't get me wrong. The space should be counted as a "character"...but
based on the initial question, they wanted to know how many charaters in a
cell are "Letters". Since a space is not a letter, and the formula is not
written to omit or substitute spaces, then the result will be incorrect if
referenced cell contains a space or spaces.

....

Fair point. To count only letters, use

=26*LEN(A22)-SUMPRODUCT(LEN(SUBSTITUTE(UPPER(A22),
MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ",ROW(INDIRECT("1:2 6")),1),"")))