Character count

[kevs]

Is there a way for excel to tell me the character count for all the cells in
a certain column? Thanks!

Kevs



OS 10.4.7
Office 2004

 

[JE McGimpsey]

Is there a way for excel to tell me the character count for all the cells in
a certain column? Thanks!

One way (array-entered: CMD-RETURN):

=SUM(LEN(A1:A100))

 

[kevs]

=SUM(LEN(A1:A100))

Thanks JE,

Do I paste =SUM(LEN(A1:A100))
And put it somewhere? And then the word count will be in the column at the
right of the last filled column? Thanks!

Kevs


OS 10.4.7
Office 2004

 

[JE McGimpsey]

Thanks JE,

Do I paste =SUM(LEN(A1:A100))
And put it somewhere? And then the word count will be in the column at the
right of the last filled column? Thanks!

I guess it depends on what you're trying to do...

You can put the function anywhere that it doesn't cause a circular
reference.

 

[kevs]

I guess it depends on what you're trying to do...

You can put the function anywhere that it doesn't cause a circular
reference.

Help me out JE!

I have a long column.
Each row in each cell has lot of text.
I want a column on right to tell me how many characters are in the text for
each cell. column. It's a huge business thing I need. Thanks!





OS 10.4.7
Office 2004

 

[JE McGimpsey]

I have a long column.
Each row in each cell has lot of text.
I want a column on right to tell me how many characters are in the text for
each cell. column. It's a huge business thing I need. Thanks!

Not sure what "for each cell. column." means...

Perhaps you can just use LEN()??:

A B
1 Big Long Text String =LEN(A1)
2 Another Text String =LEN(A2)

My first suggestion was based on your request for "the character count
for all the cells in a certain column" which I read to mean a single
total of all of the characters in that column.

If neither is what you mean, please be more explicit in what you're
looking for.

 

[kevs]

Not sure what "for each cell. column." means...

Perhaps you can just use LEN()??:

A B
1 Big Long Text String =LEN(A1)
2 Another Text String =LEN(A2)

My first suggestion was based on your request for "the character count
for all the cells in a certain column" which I read to mean a single
total of all of the characters in that column.

If neither is what you mean, please be more explicit in what you're
looking for.

NO JE!
Not total!
I have 1 columns with 100 cells.
I have blank column on the right of that columns and want to know the
character count for each and every cell.



OS 10.4.7
Office 2004