View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default 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.