title: Divide cell in excel by 3 different string patterns using vba
body: <p>I have a list with a row in excel which has three different types (pattern) of string:</p>
  
  <ol>
  <li>ABCD, CBFG, EXAL</li>
  </ol>
  
  <p>For the first type it's for example:  <strong>ABCD</strong> </p>
  
  <p>So it will always be a combination of letters and no numbers or anything else. </p>
  
  <ol start="2">
  <li>ABCD (HOLA), CBFG (HOLA), EXAN (HOLA)</li>
  </ol>
  
  <p>For the second type it's for example:   <strong>ABCD (HOLA)</strong></p>
  
  <p>So it will be always a combination of letters and a combination of letters in brackets.</p>
  
  <ol start="3">
  <li>ABCD (HOLA), SOLE, CBFG (HOLA), SUPRA, EXAN (HOLA), ITAN</li>
  </ol>
  
  <p>For the third type it's for example:     <strong>ABCD (HOLA), SOLE</strong></p>
  
  <p>So it will be always a combination of letters and a combination of letters in brackets and a comma followed by another combination of letters</p>
  
  <p>All these three types are listed with the following pattern.</p>
  
  <p>Let's say we have: ABCD and ABCD (SOLE) and ABCD (HOLA), SOLE </p>
  
  <p>Then my cell will look as follows:</p>
  
  <p>ABCD, ABCD (HOLA), ABCD (HOLA), SOLE</p>
  
  <p>Now I have the type 3 which also includes a comma. You can say there are two different commas here. One is used to divide each entry and the other one 
  is actually a part of one entry.
  What I am trying to do now is to get these three types and paste them into another cell.</p>
  
  <p>I don't know how to go about this. If someone can give me an advice on how to start that would be great.</p>
  
  <p><a href="http://i.stack.imgur.com/li7gO.png" rel="nofollow">Here is an example how I want my cell to divide the information:
  In B2 is the information I have. The range H1 to J4 is what I want to have</a> </p>