In this tutorial, you will learn how to count the number of words in a cell using the LEN() and SUBSTITUTE functions. Instead of counting the number of actual words in a cell, you are counting the number of spaces in the cell which will give you the number of words in a cell. The composability of the LEN and SUBSTITUTE functions make this a unique solution to finding the number of words in a cell.
* Intro - 0:00
* Find length of text - 0:11
* Use SUBSTITUTE function - 0:57
* Find length of text without spaces - 3:12
* SOLUTION: Final formula - 4:47
馃憠 Copy the Google Sheet: https://docs.google.com/spreadsheets/d/1UwV1RC2TXn3dJdbF-EahjXQe4CmQ3bDgbYHYV4IT4YY/edit
馃憠 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast/dear-analyst/id1455099942
馃憠 Follow on Instagram: https://instagram.com/dear.analyst
馃憠 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analyst-74-quick-hack-to-count-the-number-of-words-in-a-cell-with-len-and-substitute
馃憠 Excel for the Real World online class: https://skl.sh/2lsi6up
0 Comments