counting commas within a string

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

Hi to All,

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