Need formula for counting total Numbers in One Cell

[pvsvprasad]

Dear All,

I need one formula for counting total numbers in a Cell. and if cell is blank, result should be "0" (zero).

Kindly suggest suitable formula and please find sample file.

thanking you,
Best regards.

[Pete_UK]

Try this in C3:

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

Hope this helps.

Pete

[zbor]

Here:

Please Login or Register  to view this content.

[Phuocam]

Try this ...

=LEN(C2)-LEN(SUBSTITUTE(C2," ",""))+(LEN(C2)>0)

[pvsvprasad]

Thank you all of you friends,

all formulas are working well.


thanking you all for fast response,
Best regards.

[OzTrekker]

Try this.

Please Login or Register  to view this content.

[pvsvprasad]

Thank you sir,

All formulas are well..

Best regards.