Tag Archives: Count Number of Words

Count Number of Words in a Cell

Number of Words This example describes how to count the number of words in a cell. 1a. The TRIM function returns a string with leading spaces, extra spaces and trailing spaces removed. 1b. To get the length of the string with normal spaces, we combine the LEN and TRIM function.   2a. The SUBSTITUTE function replaces existing text… Read More »