Posting this a 2nd time as the original post did not appear
==========================================

Hi to All,

For example, cell A1 contains a text string such as 56,58,12,1,22,893
I want to determine how many numbers are contained within the string
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

It did appear, but if you are trying to read it on Google Groups there seems
to be about a one-day delay currently before posts are made visible.

Pete

<(E-Mail Removed)> wrote in message
news:52b65084-c4f0-4667-b70d-(E-Mail Removed)...
> Posting this a 2nd time as the original post did not appear
> ==========================================
>
> Hi to All,
>
> For example, cell A1 contains a text string such as 56,58,12,1,22,893
> I want to determine how many numbers are contained within the string
> 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