B
Bob Phillips
=LEN(A1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
P
Pete_UK
=LEN(A1)
Pete
Pete
R
Rick Rothstein \(MVP - VB\)
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
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
L
Leah_WI
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.
post that more elaborate function. You just saved me so much time.
R
Rick Rothstein \(MVP - VB\)
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
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
G
Glenn
Rick said:
Are you sure "Leah_WI" and "Suhasini" are the same person?
R
Rick Rothstein \(MVP - VB\)
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
=========
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
S
Spiky
Ah, the amusing side of irony. 