New Character count question

[kevs]

I have a column of 1000 rows ( each cell has keyword text ranging from 500
to 700 words.) But my client just notified me that the character count
cannot exceed 600 words.
Is there a way I can quickly determine the character count of these 1000
cells? Thanks

Kevs




OS 10.4.7
Office 2004

 

[JE McGimpsey]

I have a column of 1000 rows ( each cell has keyword text ranging from 500
to 700 words.) But my client just notified me that the character count
cannot exceed 600 words.
Is there a way I can quickly determine the character count of these 1000
cells? Thanks

Assuming that the words are all separated by one or more space
characters, one way:


=LEN(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1))

which will include the space characters (but only one in between each
word). If your client wants to count only non-space characters, then:

=LEN(SUBSTITUTE(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1)," ",""))

 

[kevs]

Assuming that the words are all separated by one or more space
characters, one way:


=LEN(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1))

which will include the space characters (but only one in between each
word). If your client wants to count only non-space characters, then:

=LEN(SUBSTITUTE(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1)," ",""))

Thanks JE, keep you posted.

Actually, the client sent me a worksheet, and the formula they are using is
=LEN(C2)

C2 being the column with the keywords.

I dig a drag and paste and it seemed to work good.


OS 10.4.7
Office 2004

 

[Charles W Davis]

Assuming that the words are all separated by one or more space
characters, one way:


=LEN(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1))

which will include the space characters (but only one in between each
word). If your client wants to count only non-space characters, then:

=LEN(SUBSTITUTE(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1)," ",
"^",600)&"^")-1)," ",""))

If you have the cells in a single column, select an empty column, then in
the first row below the header (if you have one), enter =LEN(an) Where a is
the column id and n is the row number. Then propogate this down the entire
column.