Use the LEN and SUBSTITUTE Functions to Make an Excel Formula for Word Count

 

Learn how to create an Excel formula that will perform a word count for you. By using the LEN function and the SUBSTITUTE function, you can make a formula that will let you know how many words are in a particular cell or range of cells.

Source: Technology for Teachers and Students (2023-12-25)