counting commas within a string

Giganews Newsgroups
Subject: counting commas within a string
Posted by:  Ron.Winkl…@gmail.com
Date: Tue, 8 Jul 2008

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

Replies