How to split a string with multiple delimiters in vba excel?

Question

I want to split a string with multiple delimiters using Excel VBA. One of the strings is:

d1-d2 d3 d4  

We have a dash and a space as two delimiters. I tried the split function but it only does it with one delimiter.

Answer 1

You could first do a Replace on the string first and then do the split:

newString = Replace(origString, "-", " ")
newArray = Split(newString, " ")