Thread: How to tally words in Excel?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How to tally words in Excel?
On Sat, 11 Aug 2007 19:15:49 -0500, Dave Peterson
wrote:

But to avoid returning 1 when the cell is empty:

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<"")

Good point
--ron
Reply With QuoteReply With Quote