Thanx RD.
Larry.
"Ragdyer" wrote in message
...
Try this:
=LEN(SUBSTITUTE(A1," ",""))
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Larry Wallis" wrote in message
...
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.
|