To get the word count of the whole sheet, you have to apply the same formula to every cell and add all the counts to get a final number. This is how we get the word count in an Excel sheet.

How to Create a Word Phrase Count in Excel. ... but you can work around this problem by using the "SUM" function to add up search results of all the cells around the one with the forumula.

The syntax to add a comma after first word in each cell in Excel using the Replicate function is as follows: =REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you ...