Counting CHARACTERS in a Cell

[Adgurl]

I know how to use the LEN formula to count WORDS in a cell...but is there a way to manipulate the formula to count CHARACTERS in a cell?

Here's the formula I'm using now:

=IF(LEN(TRIM(F1))=0,0,LEN(TRIM(F1))-LEN(SUBSTITUTE(F1," ",""))+1)

F1 is the cell that contains the text I'm working with.

Thanks in advance for your help!

 

[Jonmo1]

Actually, LEN DOES count the characters in a cell, not words.

You're wanting to count how many spaces there are in a cell?

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

 

[dcardno]

LEN counts characters directly: try
LEN(F1)
All the other work is to count the number of spaces (plus one) to determine the number of words...

 

[Gerald Higgins]

Err. . . . LEN does count characters.

For example,

=LEN(F1)

If you want to count characters excluding spaces, try

=LEN(SUBSTITUTE(f1," ",""))

 

[Adgurl]

Thank you guys. When I did a search in Excel help for counting Characters, all I got was this long formula for counting WORDS.


Using just the =LEN(f1) got me exactly what I wanted...counting characters INCLUDING the spaces.

Thank you for not making me feel too DUMB...but I knew you guys could help me.