![]() ![]() In this case, there are multiple space characters between words. Let’s say you have the following text: Let the cat out of the bag Example 2: When there are multiple spaces between words In that case, use the formula in the next example. But it wouldn’t work if you have more than one space in between words. Now, this works well if you have only one space character between words. For example, there is one space in two words and two spaces in three words. =LEN(A1)-LEN(SUBSTITUTE(A1,” “,“” ))+1 – We add 1 to the overall result as the total number of spaces is one less than the total number of words.In the above example, it would be 26-20 which is 6. LEN(A1)-LEN(SUBSTITUTE(A1,” “,“” )) – This would subtract the text length without spaces from the text length with spaces. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |