Thread: Count Spaces In A String
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default Count Spaces In A String
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))

--
Jim Rech
Excel MVP


Reply With QuoteReply With Quote