Please use =LEN("Cell reference") it will count the words / letters of specific
cell
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Jorge Marques
Sent: Friday, February 04, 2011 1:17 AM
To:
use len function. like u want to calculate num of latter in 1 cell, than
=len(a1).
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
> --
Hi,
use Len function..
=LEN(cell_reference)
Regards,
Manoj Kumar
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
> ---
word count -- LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1
On Fri, Feb 4, 2011 at 10:34 AM, NOORAIN ANSARI wrote:
> Dear Jorge,
>
> Please try..
>
> *For Letter Counting=Len(A1)*
> *For Word Counting=Len(A1)-Substitute(Len(A1)+1*
>
> Thanks & regards,
> Noorain Ansari
> On Fri, Feb 4, 2011 at 1:17 AM,
Dear Jorge,
Please try..
*For Letter Counting=Len(A1)*
*For Word Counting=Len(A1)-Substitute(Len(A1)+1*
Thanks & regards,
Noorain Ansari
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
>
