- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- counting the number of commas within a text string

Subject: | counting the number of commas within a text string |

Posted by: | Ron.Winklâ€¦@gmail.com |

Date: | Thu, 10 Jul 2008 |

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

- Re: counting the number of commas within a text string posted by Gord Dibben on Thu, 10 Jul 2008
- Re: counting the number of commas within a text string posted by Rick Rothstein \(MVP - VB\) on Thu, 10 Jul 2008