Thread: EXCEL: wordcount within cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default EXCEL: wordcount within cell
And if I have 2 words in the cell?

Borrowing from Mike's solutions:
=IF(A1="",0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)

--
John C


"Teethless mama" wrote:

=LEN(A1)


"CPAZO" wrote:

How do i set up wordcount within cell?
Reply With QuoteReply With Quote