View Single Post
  #5   Report Post  
JavyD
 
Posts: n/a
Default Count Text in a Cell

Man, that was too easy, made me look foolish. You guys are the best!

"Peo Sjoblom" wrote:

=LEN(A1)


--

Regards,

Peo Sjoblom


"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.