counting the number of commas within a text string

Giganews Newsgroups
Subject: counting the number of commas within a text string
Posted by:  Ron.Winkl…@gmail.com
Date: Thu, 10 Jul 2008

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

Replies