counting commas within a string

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
 
H

Harald Staff

Hi RonW

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

HTH. Best wishes Harald
 
D

Dave Peterson

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 Question 3
Counting Within a Cell 2
Excel won't let me type a formula using commas! 5
count no. of commas (,) in a string in a cell 3
Count Commas in Cells 5
Deleting commas within quotes 2

Top