How to count the number of letters in a cell?
 

How to count the number of letters in a cell?
 

=LEN(A1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Suhasini" wrote in message
...

How to count the number of letters in a cell?
 

=LEN(A1)

Pete

On Aug 21, 8:19*am, Suhasini
wrote:

How to count the number of letters in a cell?
 

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

How to count the number of letters in a cell?
 

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

How to count the number of letters in a cell?
 

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

How to count the number of letters in a cell?
 

Rick Rothstein (MVP - VB) wrote:
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



Are you sure "Leah_WI" and "Suhasini" are the same person?

How to count the number of letters in a cell?
 

Glenn:
=========
Ooh... no, I am not. I missed the name switch and the wording of Leah's
message sounded like a follow up response from the OP. Based on that
wording, it never occurred to me to check if the names were different.
Thanks for point that out.

Leah
=========
If you are not the original poster, then I am sorry for the "admonishment".

Rick


"Glenn" wrote in message
...
Rick Rothstein (MVP - VB) wrote:
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



Are you sure "Leah_WI" and "Suhasini" are the same person?

How to count the number of letters in a cell?
 

Ah, the amusing side of irony. :-)