COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL?

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.

Hello zurafz6,

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

=LEN(Cell)

Judith

"zurafz6" wrote:

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.

Try this:


=LEN(A1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zurafz6" wrote in message
...
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.

Hi!

=LEN(A1)

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

Biff

"zurafz6" wrote in message
...
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.

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.

"Biff" wrote:

Hi!

=LEN(A1)

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

Biff

"zurafz6" wrote in message
...
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.

Thanks. It works.

"Ragdyer" wrote:

Try this:


=LEN(A1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zurafz6" wrote in message
...
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.

Thanx a million. It helps.

"JudithJubilee" wrote:

Hello zurafz6,

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

=LEN(Cell)

Judith

"zurafz6" wrote:

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.

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 DataValidation
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

"zurafz6" wrote in message
news
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.

"Biff" wrote:

Hi!

=LEN(A1)

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

Biff

"zurafz6" wrote in message
...
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.