EXCEL 中计算单元格中的总字数

“=IF(LEN(A1)=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),〃,〃,〃〃))+1)”

这个公式怎么运用啊

---

=LEN(SUBSTITUTE(TRIM(A1)," ",""))

---