title: VBA - How to build an array with multiple delimiters of varying sizes?
body: <p>How can I build an array if I have multiple delimiters, where some delimiters are single character and others are multiple characters?</p>
  
  <pre><code>Sub Example()
      Dim exString As String
      Dim myString() As String
  
      exString = "A,B C;D &gt; E"
  
      myString() = Split(exString, "," &amp; " " &amp; ";" &amp; " &gt; ")
  End Sub
  </code></pre>
  
  <p>The result I want in my array is:</p>
  
  <pre><code>myString(0) is A
  myString(1) is B
  myString(2) is C
  myString(3) is D
  myString(4) is E
  </code></pre>
  
  <p>But using <code>Split()</code> in this way doesn't work. I do know that I can use <code>Replace()</code> to replace every single delimiter with a common one, but I have a lot of different delimiters and variations of multiple character delimiters. Using <code>Replace()</code> isn't desirable to me. What can I do?</p>