counting commas within a string

  • Thread starter Thread starter Ron.Winkley
  • Start date Start date
R

Ron.Winkley

Hi to All,

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 RonW

Length of string minus length of sting without commas:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

HTH. Best wishes Harald
 
If you want to count the number of "elements" that are separated by commas:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<>"")
 

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 1
counting the number of commas within a text string 2
Counting Within a Cell 2
Excel VBA - Force 4 commas into a text field on userform 7
Counting Question 3
Adding comma seperated values within a single cell 2
count no. of commas (,) in a string in a cell 3
Excel won't let me type a formula using commas! 5

Back
Top