Excel basic tutorial: calculating the total number of words in a cell.Sometimes, we may be interested in the number of characters in a cell, and we need to calculate the total number of words in a cell.To solve this problem, in addition to the use of ldquo; SUBSTITUTE; the virtual computing of the function, we also use ldquo; TRIM; function to delete the space.For example, now the A1 cell is entered with ldquo; how many words; the words, then we can help with the following expressions: =如果(LEN(A1)= 0,0,len(TRIM(A1))-莱恩(替代(TRIM(A1); 这个公式的意义是用substitute函数创建一个新字符串并使用trim功能;删除字符之间的空间,然后计算原始字符串和数字的区别,从而得出空间;,在1细胞的数量的空格数。字符。