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.

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.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484407

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.

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

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.