In certain situations, you might want to check how many words have been included in a given cell inside the spreadsheet you are working on. If that’s the case, you can use the following formula to count the words in a cell of your spreadsheet. The formula you will see inside the template leverages a smart combination of the LEN and SUBSTITUTE functions.

Some other related topics you might be interested to explore are Count Numbers that Fall in a Range and Count Unique Values in a Range.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Business Analyst, Consultant, Corporate Executive, or everyone preparing a corporate presentation.

You can now download the Excel template for free.