Count Text in a Cell

[Guest]

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.

 

[Cutter]

Use the LEN() function.

If A1 contains the word test

Then putting the formula =LEN(A1) in another cell will return 4

It also counts spaces

 

[PCLIVE]

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

 

[Peo Sjoblom]

=LEN(A1)

 

[Guest]

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