View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Count number of tab characters in a string

Hi Robert,

Am Wed, 9 Oct 2019 03:49:14 -0700 (PDT) schrieb RG III:

What?s a quick way to count the number of tab characters in a string variable?


try:

i = Len(myStr) - Len(Replace(myStr, vbTab, ""))

where is is the number of tab characters


Regards
Claus B.
--
Windows10
Office 2016