CODEWITHSUNDEEP
excelexcel-formula
Unicorn
Unicorn

Reputation: 51

Count the strings inside an excel column

Having an excel column as below:

excel

I need to find out the number of words in the column.

mg

Upvotes: 0

Views: 45

Answers (2)

Harun24hr
Harun24hr

Reputation: 37050

Try below formula-

=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1

For dynamic spill array.

=MAP(A2:A5,LAMBDA(x,LEN(x)-LEN(SUBSTITUTE(x,",",""))+1))

enter image description here

Upvotes: 2

Jos Woolley
Jos Woolley

Reputation: 9062

If you have TEXTSPLIT:

=COUNTA(TEXTSPLIT(A1,","))

Upvotes: 1

Related Questions