Excel VBA count substring occurrences in string February 9, 2016 Posted by silver count = (Len(myTxt) - Len(Replace(myTxt, countTxt, ""))) / Len(countTxt) Updated: February 10, 2016 at 9:44 am ◀ DATA East Tales From The Crypt ROMS DB2 SQL Extract hierarchy from linked list like table ▶