Count the number of Commas found in cell A2
 

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????

Count the number of Commas found in cell A2
 

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~O~B" wrote in message
...
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????

Count the number of Commas found in cell A2
 

On Apr 2, 11:59 am, "Ron Coderre"
wrote:
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~O~B" wrote in message

...



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????- Hide quoted text -

- Show quoted text -

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

Count the number of Commas found in cell A2
 

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

Regards,

Ron
Microsoft MVP (Excel)


"B~O~B" wrote in message
...
On Apr 2, 11:59 am, "Ron Coderre"
wrote:
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~O~B" wrote in message

...



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????- Hide quoted text -

- Show quoted text -

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