Having an excel column as below:
I need to find out the number of words in the column.
6qqygrtg1#
尝试以下公式-
=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1
用于动态溢出数组。
=MAP(A2:A5,LAMBDA(x,LEN(x)-LEN(SUBSTITUTE(x,",",""))+1))
jvlzgdj92#
如果您有TEXTSPLIT：=COUNTA(TEXTSPLIT(A1,","))
TEXTSPLIT
=COUNTA(TEXTSPLIT(A1,","))
2条答案
按热度按时间6qqygrtg1#
尝试以下公式-
用于动态溢出数组。
jvlzgdj92#
如果您有
TEXTSPLIT：=COUNTA(TEXTSPLIT(A1,","))