R
Ron.Winkley
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
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