Thread: Count Spaces In A String
View Single Post
  #1   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
Or in VB:

Len(Strg) - Len(Replace(Strg, " ", ""))

--
Jim Rech
Excel MVP


Reply With QuoteReply With Quote