Calculating number of letters in a string ...

L

Larry Wallis

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

Geovas

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
 
L

Larry Wallis

Thanx RD.

Larry.


Ragdyer said:
Try this:

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

RD

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

string.
Click to expand...
 
L

Larry Wallis

And thanx to u too Geovas.

Larry.


Geovas said:
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



string.
Click to expand...
 
Top