COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL?

[zurafz6]

Im currently creating codes for our inventory list. The system provider
mentioned that my codes can only have 30 characters including spaces and
symbols. Now I have my list but it will be easy for me if there is a function
which will help me count the number of characters in a cell. From there I
will be able to identify those codes which exceed 30 characters and modify my
list.

Thanks. It will be a great help.

 

[JudithJubilee]

Hello zurafz6,

You can use the LEN function. This counts the number of charcters in a cell.

=LEN(Cell)

Judith

 

[Ragdyer]

Try this:


=LEN(A1)

 

[Biff]

Hi!

=LEN(A1)

You could also set it up to reject codes longer than 30 characters, if you
were so inclined.

Biff

 

[zurafz6]

Hi Biff
Thanks it helps. How do I then formulate to reject codes more than 30. What
is the formula and will it help me identify. Thanks again.

 

[zurafz6]

Thanks. It works.

Try this:


=LEN(A1)

 

[zurafz6]

Thanx a million. It helps.

Hello zurafz6,

You can use the LEN function. This counts the number of charcters in a cell.

=LEN(Cell)

Judith

 

[Biff]

Hi!

It would not help to identify as that would be "after the fact". It will
prevent** you from entering codes longer than 30 characters in the first
place.

Select the range of cells in question.
Assume that range is A1:A1
Goto Data>Validation
Allow: Text length
Data: Less than or equal to
Maximum: 30
OK

** - prevent means, if the codes are manually typed in. Validated cells can
still be pasted into or dragged to.

Biff