Count the number of Commas found in cell A2

B

B~O~B

Is there a way to count the number commas (,) in a cell?? I am doing
a text to column by Commas (,) then doing a Countif on the data to get
my number... Is there a was to count with doing the text to column????
 
R

Ron Coderre

Here's one way to count
the number of commas in a cell:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
B

B~O~B

Here's one way to count
the number of commas in a cell:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)






- Show quoted text -
Click to expand...

Work for me.... Thanks you very much...
 
R

Ron Coderre

You're welcome.....I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)
 

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

How to count the numbers in a Word document? 0
Select Text to End of Footnote 9
count no. of commas (,) in a string in a cell 3
Found few bugs in my daily routine of work in excel for MAC 0
Using <= in countifs statement 1
Excel does not accept text format! 0
How to count commas in a cell? 5
Found few bugs in my daily routine of work in excel for MAC 0

Top