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