|Subject:||counting the number of commas within a text string|
|Date:||Thu, 10 Jul 2008|
Hi to All,
Cell A1 contains a text string such as 56, 58, 12, 1, 22, 893 or it
I want to determine how many values are contained within the string
[in this case only 6, but could be more] Simply, counting the
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,