Thread: How to tally words in Excel?
View Single Post
  #2   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 06:46:00 -0700, Looking for answers <Looking for
wrote:



Count the spaces; add one (1)

=1+LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))
--ron
Reply With QuoteReply With Quote