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