title: Excel - Extract all occurrences of a String Pattern + the subsequent 4 characters after the pattern match from a cell
body: <p>I am struggling with a huge Excel sheet where I need to extract from a certain cell (A1), 
  all occurrences of a string pattern e.g. "TCS" + the following 4 characters after the pattern match e.g. TCS1234 comma-separated into another cell (B1).</p>
  
  <p>Example:</p>
  
  <p>Cell A1 contains the following string:</p>
  
  <pre><code>HRS164, SRS3439(s), SRS3440(s), SRS3441(s), SRS3442(s), SRS3443(s), SRS3444(s), SRS3445(s), SRS3449(s), SRS3450(s), SRS3451(s), SRS3452(s), SYSBASE.SSS300(s), TCS3715(s), TCS3716(s), TCS3717(s), TCS4037(s), TCS1234
  </code></pre>
  
  <p>All TCS-Numbers shall be comma-separated in B1: </p>
  
  <pre><code>TCS3715, TCS3716, TCS3717, TCS4037, TCS1234
  </code></pre>
  
  <p>It is not necessary to also extract the followed "(s)".</p>
  
  <p>Could someone please help me (excel rookie) with this challenge?</p>
  
  <p>TIA Erika</p>