Count Characters in a Cell

**TOTO_POP** · 08-05-2010, 07:01 PM

Peace to you All
Is there a formula ( or a VBA Code ) to count Characters in a cell ??
i.e :
The name:
Parak Hussein Opama
is in Cell A1 . I need a formula to return 3 in Cell B1
any help 'd be greatly appreciated

**Paul** · 08-05-2010, 07:04 PM

Hi Toto_pop, welcome to the forum.

If you're trying to count characters, you would use:

=LEN(A1)

But that would count each character, not each word. Since you want the result to be 3, I assume you meant that you want to count the number of words in a cell. If that's the case, use:

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