![]() If you don’t use the IF function, the formula will return 1 even when the cell is empty. The COUNTA function then simply counts the total number of these delimited values.Īnd the reason I have used the IF formula is to make sure I get a blank when there is no text in the cell. In this formula, my delimiter is a space character, so the SPLIT function would give me an array of text string delimited by the space character. The above formula uses the SPLIT function, which separates the text string based on the delimiter. The following formula will give you the word count: = IF ( A2 = "", "", COUNTA ( SPLIT ( A2, " " ) ) ) Suppose you have a dataset as shown below and you want to get the word count in each. ![]() Count the Number of Lines in a Text in a Cell.Get the Word Count When Words are of a Specific Length. ![]()
0 Comments
Leave a Reply. |