Counting # of items in a single cell

[CentaurSaratoga]

Hi there, I'm trying to count the number of items in a single cell, for example: 1,2,5,9 should = 4. Thank you in advance for your help!

 

[Robert Mika]

Hi CentaurSaratoga and welcome to the board
If your data are in A1 and divided by coma.

=LEN(TRIM(SUBSTITUTE(A1,",","")))

 

[West Man]

Try: =LEN(TRIM(A1))-LEN(TRIM(SUBSTITUTE(A1,",","")))+1

 

[CentaurSaratoga]

Sir,Thank You Kindly.

 

[West Man]

Glad to be of assistance.

 

[CentaurSaratoga]

Thank You West Man.

 

[CentaurSaratoga]

Hello again! The formula works wonderfully, but only for whole numbers. Is there a way that the formula could work for these numbers:

A: 3/5,6/5, etc. <<--- This method preferably, or
B: .6,1.2, etc.

Thanks again gentlemen!

 

[West Man]

Robert Mika's formula gives a count of digits (7,13 would result in 3), my formula gives a count of numbers (7,13 would result in 2).

It appears that Robert's formula is your desire, so modified for your first preference it would be : =LEN(TRIM(SUBSTITUTE(SUBSTITUTE(A1,",",""),"/","")))