Is there a function in excel that counts the number of items seperated by commas in one cell?
S smcgee01 Mar 25, 2009 #1 Is there a function in excel that counts the number of items seperated by commas in one cell?
D Dave Peterson Mar 25, 2009 #2 =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<>"") Is there a function in excel that counts the number of items seperated by commas in one cell? Click to expand...
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<>"") Is there a function in excel that counts the number of items seperated by commas in one cell? Click to expand...
R Rick Rothstein Mar 25, 2009 #3 Odd... this same question was asked yesterday by a different person over in the worksheet.functions newsgroup. Homework assignment maybe?
Odd... this same question was asked yesterday by a different person over in the worksheet.functions newsgroup. Homework assignment maybe?
D Dave Peterson Mar 25, 2009 #4 It's a common question. In fact, it's similar to the first question I ever asked in the newsgroups (how many X's in a cell). (The answer hasn't changed in a few years <vbg>.)
It's a common question. In fact, it's similar to the first question I ever asked in the newsgroups (how many X's in a cell). (The answer hasn't changed in a few years <vbg>.)
