excel如何统计一格单元格内某个单词出现的次数?

2024-12-22 18:48:18
推荐回答(2个)
回答1:

假设单元格的值在A1,在B1输入公式:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"full","")))/LEN("full")

回答2:

假设数据在A1,B1用公式得到"full"的出现次数:
=(LEN(A1)-LEN(SUBSTITUTE(A1,"full","")))/4