Is there a character count feature in Excel?
 

I am trying to figure out if there is a way to count characters in an
individual cell. My requirement limit is 25 characters but I am starting
with cell data that is much more than that. I have to reduce the count while
maintaining the intelligence of the cell information. I must do this
literally hundreds of times. It would make life much easier to have a
running count visible rather than to count each character in each cell every
time.

Is there a character count feature in Excel?
 

=LEN(A1) will count the characters in that cell.

"Bob S" wrote:

I am trying to figure out if there is a way to count characters in an
individual cell. My requirement limit is 25 characters but I am starting
with cell data that is much more than that. I have to reduce the count while
maintaining the intelligence of the cell information. I must do this
literally hundreds of times. It would make life much easier to have a
running count visible rather than to count each character in each cell every
time.

Is there a character count feature in Excel?
 

Try the len() function.

HTH.

"Bob S" wrote:

I am trying to figure out if there is a way to count characters in an
individual cell. My requirement limit is 25 characters but I am starting
with cell data that is much more than that. I have to reduce the count while
maintaining the intelligence of the cell information. I must do this
literally hundreds of times. It would make life much easier to have a
running count visible rather than to count each character in each cell every
time.

Is there a character count feature in Excel?
 

Perfect. Thanks...

"DaveO" wrote:

Try the len() function.

HTH.

"Bob S" wrote:

I am trying to figure out if there is a way to count characters in an
individual cell. My requirement limit is 25 characters but I am starting
with cell data that is much more than that. I have to reduce the count while
maintaining the intelligence of the cell information. I must do this
literally hundreds of times. It would make life much easier to have a
running count visible rather than to count each character in each cell every
time.

Is there a character count feature in Excel?
 

Perfect. Thanks...

"bpeltzer" wrote:

=LEN(A1) will count the characters in that cell.

"Bob S" wrote:

I am trying to figure out if there is a way to count characters in an
individual cell. My requirement limit is 25 characters but I am starting
with cell data that is much more than that. I have to reduce the count while
maintaining the intelligence of the cell information. I must do this
literally hundreds of times. It would make life much easier to have a
running count visible rather than to count each character in each cell every
time.