Count Text in a Cell

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

[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

"JavyD" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Peo Sjoblom]

=LEN(A1)


--

Regards,

Peo Sjoblom


"JavyD" <[email protected]> wrote in message
news:[email protected]...
> 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.

[JavyD]

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

"Peo Sjoblom" wrote:

> =LEN(A1)
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "JavyD" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>