Count occurences in string 1

[sylve]

What i want to do is pretty simple. Count the number of "." there are in a string.

Isn't there a easy method to do this?

 

[TonyJollans]

Hi sylve,

The easiest way I know ..

[blue][tt] Len(YourString) - Len(Replace(YourString, ".", ""))[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[strongm]

Or

Ubound(Split(YourString,"."))