Is there a formula that will count the number of characters, and spaces
between characters, in a short paragraph created by a string text? It
is acceptible if spaces cannot be counted. Thanks.

Michael

You have to give an example, becuase your description is very cryptic.

Show a sample string of text, illustrate the characters that ou want
the space between, and the expected result.

Cheers,
Jason Lepack

mrlan...@hotmail.com wrote:
> Is there a formula that will count the number of characters, and spaces
> between characters, in a short paragraph created by a string text? It
> is acceptible if spaces cannot be counted. Thanks.
>
> Michael

One way:

=LEN(A1)

will count all the characters in cell A1.

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

will count all the non-space characters in A1

In article <(E-Mail Removed)>,
(E-Mail Removed) wrote:

> Is there a formula that will count the number of characters, and spaces
> between characters, in a short paragraph created by a string text? It
> is acceptible if spaces cannot be counted. Thanks.
>
> Michael

For example, if cell A1="Dogs bark in the night." and B1="But cats are
quiet.", and if I wanted the two to string I would use the formula:

=A1&" "&A2

This would give the the short paragraph: Dogs bark in the night. But
cats are quiet. What I need to do is count the characters in the
statement, along with spaces if possible. In this case, there are 34
characters and 9 spaces if 2 are counted between the sentences. I'm
hoping to find a formula that will do the count automatically. Thanks.

Michael

Thank you JE. I'll give it a try.

Michael

Thanks JE. It's exactly what I was looking for.

Michael

One way:

Assume the concatenation is in C1:

="There are " & LEN(SUBSTITUTE(C1," ","")) & " characters and " &
LEN(C1)-LEN(SUBSTITUTE(C1," ","")) & " spaces."



In article <(E-Mail Removed)>,
(E-Mail Removed) wrote:

> For example, if cell A1="Dogs bark in the night." and B1="But cats are
> quiet.", and if I wanted the two to string I would use the formula:
>
> =A1&" "&A2
>
> This would give the the short paragraph: Dogs bark in the night. But
> cats are quiet. What I need to do is count the characters in the
> statement, along with spaces if possible. In this case, there are 34
> characters and 9 spaces if 2 are counted between the sentences. I'm
> hoping to find a formula that will do the count automatically. Thanks.
>
> Michael