title: Splitting string to parts with specific pattern and conditions
body: <p>I have the below-like array of about 5k+ strings as output from certain application (for security reasons I may not provide the exact data, but the example format is pretty much similar to the actual data):</p>
  
  <pre><code>kasdfhkasdhfaskdfj42345sdsadkfdkfhasdf5345534askfhsad
  asdfasdf66sdafsdfsdf4560sdfasdfasdf
  sdfaasdfs96sadfasdf65459asdfasdf
  sadfasdf8asdfasdas06666654asdfasdfsd
  fasdjfsdjfhgasdf6456sadfasdfasdf9sdfasdfsadf
  </code></pre>
  
  <p>Simply, I have non-breaking alphanumeric string that consists of <strong>5 parts</strong>:</p>
  
  <pre><code>[latin letters][1 or more digits][latin letters][1 or more digits][latin letters]
  </code></pre>
  
  <p>Length of letter parts, as well as amount of digits is random, overall string length may vary from <em>several</em> to 2-3 <strong><em>hundreds</em></strong> of chars, but the pattern is still as above.</p>
  
  <p>Practically I'm interested in <strong>leading and trailing string parts</strong>, i.e. <code>[1 or more digits][latin letters][1 or more digits]</code> may be just thrown away, but 2 other strings should be extracted to separate cells.</p>
  
  <p>I tried <code>SUBSTITUTE</code> and <code>SEARCH</code> functions, but I still may not handle random amount of digits. VBA is the last desired approach, however it is acceptable in case pure formulas are  useless. Moreover, the solution should be flexible for possible future use with similar patterns - so any right guidance / general approach will be appreciated.</p>