View Single Post
  #3   Report Post  
PCLIVE
 
Posts: n/a
Default Count Text in a Cell

Try:

To count the number of characters in a case, including spaces.
=len(A1)

And to change a description based on greater than 30.
=IF(LEN(A1)30,"description change","no change")

Regards,
Paul

"JavyD" wrote in message
...
Hello, is it possible to count the number of text in a cell. I need to
change descriptions on items if the number of text in that description is
larger than 30. Sort of like a validation I guess. But I just want a
formula so that I can sort by that formula and change those descriptions
that
have a text value, including spaces, etc, that is greater than 30.

Thanks.