It looks like I finished my work after somebody already took an approach. Still you may want to use the function I wrote. It is shown below and I have attached the spreadsheet where I show how it works. Like any other function just type =WordsWithCounts(put your cell range to test here) and it should work. One trick though, if you want the linefeeds to work so each word shows on a different line you have to format the cell you are putting the formula in to Wrap Text before it calculates the formula.
Bookmarks