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

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