excel - How to find Number of Occurences of Slash from a strings

Question

How can I find the number of occurrences of the forward slash character ( / ) within a string using an Excel VBA macro?

Answer 1

Old question, but I thought I would add to the quality of the answer by an answer I found at an excel forum. Apparently the count can also be found using.

    count =Len(string)-Len(Replace(string,"/",""))

Full credit for the answer goes to the original author at:http://www.ozgrid.com/forum/showthread.php?t=45651