delimiter is the characters around which you want the text to split.It uses four arguments to carry out this operation, although only two of those are compulsory. The SPLIT function separates a specified text string around a given delimiter and places each segment of the divided text string into separate cells. = COUNTA ( value1, )ĬOUNTA returns the count of the numeric and string values in a range. This is another method that you can use to achieve the same result. Count the Number of Words in a Cell with the COUNTA and SPLIT Functions You can use the TRIM function, to clean up all leading and trailing spaces. While you might be able to see the leading spaces, the trailing spaces are invisible. = LEN ( TRIM ( A1 ) ) - LEN ( SUBSTITUTE ( TRIM ( A1 ), ' ', '' ) ) + 1

That is a result of the trailing and leading spaces in each cell.

But the output is showing different results. In the above example, it’s clear the number of words in each cell is two. The drawback to the method is that the syntax is susceptible to leading and trailing spaces. You can copy and paste down the formula and get the word count of the other cells. The syntax returns the number of spaces in the cell and adding 1 to it will give you the number of words inside the cell. The number 1 is added to the syntax because the number of spaces in a sentence is one less than the total number of words. That is because the SUBSTITUTE function has been used to remove the space within the text. LEN(SUBSTITUTE(A1,' ','') will return the number of characters in cell A1 minus the spaces. In the above formula syntax, LEN(A1) will return the number of characters in cell A1 which is 6. Subtracting these two results and adding 1 to their output will give you the number of words inside the cell. Since the LEN function returns the number of characters in a cell including the spaces, the SUBSTITUTE function will allow you to get the number of characters in a cell without the spaces.

You can then count the number of characters in your text with spaces and without spaces using the LEN function. You can use the SUBSTITUTE function to create a version of your text without any space characters. The SUBSTITUTE function does the job of finding text and replacing it with another bit of text. = SUBSTITUTE ( text_to_search, search_for, replace_with, ) We will have to introduce another function, the SUBSTITUTE function. On its own, LEN wouldn’t be able to count the number of words in a cell. The LEN function typically returns the number of individual characters in a cell, including spaces. Count the Number of Words in a Cell with the LEN and SUBSTITUTE Functions = LEN ( text ) In this post, you will learn how you can use a combination of functions to count the number of words in Google Sheets.

Does google docs have a word counter