Thanks David. Thanks Dave.
Both formulas work for me, appreciate your time.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.


"Dave Peterson" wrote:

Another one that will count the number of "words" separated by spaces:

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<"")

Learning Excel wrote:

Do you happen to have a formula to count WORDS in a cell ?
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

"Learning Excel" wrote:

Thanks a lot David Biddulph.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.


"David Biddulph" wrote:

=LEN(SUBSTITUTE(A1," ",""))
--
David Biddulph

"Learning Excel" wrote in message
...
My formula is =LEN(A1) and copied down.
Is there a variation of this formula to count just the letters in each
cell
without counting the spaces between words ?
Thanks for the reply.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.




--

Dave Peterson