K
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
a certain column? Thanks!
Kevs
OS 10.4.7
Office 2004
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
kevs <[email protected]> said: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))
K
kevs
Thanks JE,=SUM(LEN(A1:A100))
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
J
JE McGimpsey
kevs <[email protected]> said: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.
K
kevs
Help me out JE!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.
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
J
JE McGimpsey
kevs <[email protected]> said: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.
K
kevs
NO JE!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.
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