Thread: Calculating number of letters in a string ...

Looking for a way to calculate the number of characters in a text string. I
can use the LEN function.

e.g. If A1 contains "News Group", the number of characters is 9. Using the
LEN(A1) formula would give me 10 (includes the space).

How can I use this formula to omit the space?

Thanks.

Larry.

Try this:

=LEN(SUBSTITUTE(A1," ",""))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Larry Wallis" <larrywallis@CHEATTHESPAMgmail.com> wrote in message
news:5OadnSJMsMVW_InfRVnyhA@pipex.net...
> Looking for a way to calculate the number of characters in a text string.
I
> can use the LEN function.
>
> e.g. If A1 contains "News Group", the number of characters is 9. Using the
> LEN(A1) formula would give me 10 (includes the space).
>
> How can I use this formula to omit the space?
>
> Thanks.
>
> Larry.
>
>

suppose the Word "News Group" is in cell A1 use the following formula in B1:
=LEN(SUBSTITUTE(A1," ",""))

This will first substitute all spaces in the string with nothing and then
return the length of the new string giving you the desired length....

Hope this Helps



Ã� "Larry Wallis" <larrywallis@CHEATTHESPAMgmail.com> Ã�ãñáøå óôï ìÞÃ*õìá
news:5OadnSJMsMVW_InfRVnyhA@pipex.net...
> Looking for a way to calculate the number of characters in a text string.
I
> can use the LEN function.
>
> e.g. If A1 contains "News Group", the number of characters is 9. Using the
> LEN(A1) formula would give me 10 (includes the space).
>
> How can I use this formula to omit the space?
>
> Thanks.
>
> Larry.
>
>

Thanx RD.

Larry.


"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:Ovvk3PNFFHA.4052@TK2MSFTNGP14.phx.gbl...
> Try this:
>
> =LEN(SUBSTITUTE(A1," ",""))
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
>
> "Larry Wallis" <larrywallis@CHEATTHESPAMgmail.com> wrote in message
> news:5OadnSJMsMVW_InfRVnyhA@pipex.net...
> > Looking for a way to calculate the number of characters in a text
string.
> I
> > can use the LEN function.
> >
> > e.g. If A1 contains "News Group", the number of characters is 9. Using
the
> > LEN(A1) formula would give me 10 (includes the space).
> >
> > How can I use this formula to omit the space?
> >
> > Thanks.
> >
> > Larry.
> >
> >
>

And thanx to u too Geovas.

Larry.


"Geovas" <nomail@antispam.com> wrote in message
news:cv1oh6$h5u$1@newsmaster.pub.dc.hol.net...
> suppose the Word "News Group" is in cell A1 use the following formula in
B1:
> =LEN(SUBSTITUTE(A1," ",""))
>
> This will first substitute all spaces in the string with nothing and then
> return the length of the new string giving you the desired length....
>
> Hope this Helps
>
>
>
> Ã� "Larry Wallis" <larrywallis@CHEATTHESPAMgmail.com> Ã�ãñáøå óôï ìÞÃ*õìá
> news:5OadnSJMsMVW_InfRVnyhA@pipex.net...
> > Looking for a way to calculate the number of characters in a text
string.
> I
> > can use the LEN function.
> >
> > e.g. If A1 contains "News Group", the number of characters is 9. Using
the
> > LEN(A1) formula would give me 10 (includes the space).
> >
> > How can I use this formula to omit the space?
> >
> > Thanks.
> >
> > Larry.
> >
> >
>
>