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细胞的数量的空格数。字符。