title: VBA Complex multi delimiter split
body: <p>I have a complicated split I need to do in VBA excel. I have a column of cells containing the strings like this example:</p>
  
  <pre><code>Name1 (10%), Name2 (50%), Name3, Name4 (40%)
  </code></pre>
  
  <p>I need to split this string and return each value to specific cells on the worksheet that are non adjacent. Example:</p>
  
  <pre><code>Name1  - Cell B1
  10%    - Cell C1
  Name2  - Cell M1
  50%    - Cell N1
  Name3  - Cell X1
  (blank)- Cell Y1
  Name4  - Cell AD1
  40%    - Cell AE1
  </code></pre>
  
  <p>The main problem I'm having coming up with a solution to this is that the strings can be any length. </p>
  
  <p>They may contain: </p>
  
  <p>1-10 names, </p>
  
  <p>each name <strong>may</strong> or <strong>may not</strong> have a percentage after it</p>
  
  <p>I'm still doing research and testing, but I can't find a real viable solution. Any ideas would be greatly appreciated</p>