Hi to All,

Cell A1 contains a text string such as 56, 58, 12, 1, 22, 893 or it
could
be 56,58,12,1,22,893

I want to determine how many values are contained within the string
[in this case only 6, but could be more] Simply, counting the
commas
and adding 1 one seems to be the easy answer?

How can I create an Excel formula to count the commas, or please
suggest an alternative method.

Thanks for your help,

Cheers,
RonW

Try this...

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

Rick


<(E-Mail Removed)> wrote in message
news:6d78f2e8-60bd-4a88-9c3e-(E-Mail Removed)...
> Hi to All,
>
> Cell A1 contains a text string such as 56, 58, 12, 1, 22, 893 or it
> could
> be 56,58,12,1,22,893
>
> I want to determine how many values are contained within the string
> [in this case only 6, but could be more] Simply, counting the
> commas
> and adding 1 one seems to be the easy answer?
>
> How can I create an Excel formula to count the commas, or please
> suggest an alternative method.
>
> Thanks for your help,
>
> Cheers,
> RonW

Did you not read all the replies you got to this same question July 8th?

Here they are.......

http://tinyurl.com/6syoda


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 11:54:58 -0700 (PDT), (E-Mail Removed) wrote:

>Hi to All,
>
>Cell A1 contains a text string such as 56, 58, 12, 1, 22, 893 or it
>could
>be 56,58,12,1,22,893
>
>I want to determine how many values are contained within the string
>[in this case only 6, but could be more] Simply, counting the
>commas
>and adding 1 one seems to be the easy answer?
>
>How can I create an Excel formula to count the commas, or please
>suggest an alternative method.
>
>Thanks for your help,
>
>Cheers,
>RonW