• Home
 · 
• String Manipulation
 · 
• Substring Count - Very short and efficient code - 2 Lines of code

Substring Count - Very short and efficient code - 2 Lines of code

Substring Count - Very short and efficient code - 2 Lines of code

Rate Substring Count - Very short and efficient code - 2 Lines of code

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

  If InThis = "" Or HowManyOfThese = "" Then Exit Function
  SubstringCount = (Len(InThis) - Len(Replace(InThis, HowManyOfThese, "", Compare:=CompareMethod))) / Len(HowManyOfThese)

End Function