counting the number of commas within a text string

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting commas within a string 3
counting commas within a string 1
Excel VBA - Force 4 commas into a text field on userform 7
count no. of commas (,) in a string in a cell 3
Text string searches 3
Deleting commas within quotes 2
counting the number of instances of a string within another string 3
Add commas to text string in VBA 6

Top