counting commas within a string

R

Ron.Winkley

Posting this a 2nd time as the original post did not appear
==========================================

Hi to All,

For example, 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
 
P

Pete_UK

It did appear, but if you are trying to read it on Google Groups there seems
to be about a one-day delay currently before posts are made visible.

Pete
 

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 3
counting the number of commas within a text string 2
Counting Question 3
Counting Within a Cell 2
count no. of commas (,) in a string in a cell 3
Deleting commas within quotes 2
Add commas to text string in VBA 6
counting the number of instances of a string within another string 3

Top