Take particular note of the first paragraph of my initial response to you.
If you had explained in detail what you were after in the body of the
message, you would have increased your chances of getting the response you
needed right away. Just so you are aware, I almost did not respond to your
posting because of the lack of message body text. The third time I looked at
your subject line, the idea for the formula I posted came to mind. For
future questions you might ask... do yourself a favor an explain what you
have and what you are looking for in detail (in the message area of your
posting).

Rick


"Leah_WI" wrote in message
...
This happened to be EXACTLY what I needed. Thank you for taking the time
to
post that more elaborate function. You just saved me so much time.

"Rick Rothstein (MVP - VB)" wrote:

See, this is where using all that white space in the body of the message
would have come in handy... then you could have explained **exactly**
what
you want and we wouldn't have to guess.

What are you actually after... the number of characters in the cell (what
your other responses have told you how to do) or do you have a mixture of
numbers, letters and, perhaps, other characters and you want (as your
Subject says), the count of only the letters? If that is what you meant,
try
this...

=SUMPRODUCT(--ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("A$1:A"&LEN(A1 ))),1),"abcdefghijklmnopqrstuvwxyz")))

Rick