I'm looking for a formula that will count commas or count items deliniated by
commas in cells. I've got table data in column A like:

A1=red, blue, green
A2=blue, Fred
A3=Can, jar, stack

And I need to count the elements in each cell. So, after the formula the
cells would list:
B1=2
B2=1
B3=2
(if counting commas) or:
3
2
3
(if counting items)

I then ultimately plan on running a piviot table off of Column B to indicate
by percent of the entries have 1, 2, 3, 4, etc. items listed in them.

Anyone got a way of doing that?

Thanks in advance for your help!
- Dax