View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jhicsupt jhicsupt is offline
external usenet poster
 
Posts: 25
Default Count values between commas

I need to be able to count how many entries are separated by commas. For
instance, in cell A2, I have:
AB1, AB2, AB3, AB4.
In cell B2, I want to display the number 4 because there are 4 values.

So if I have
AXX2, Ax3, A3TU0
In cell B2, I want to display the number 3 because there are 3 values.

Is there a way to do this?

Thanks in advance.