Count Text in a Cell

J

JavyD

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

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
 
P

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
 
Top