title: extract text from cells after string pattern in Excel
body: <p>I have a spreadsheet an in each cell there's a chunk of data but I am only interested in extracting a particular piece of information, after including the FIRST date up until the word "Base" example:</p>
  
  <p>FROM -></p>
  
  <pre><code>[extra data] 10APR18 [in between text] 11JUL18 [in between text] etc. Base [extra data]
  </code></pre>
  
  <p>TO -></p>
  
  <pre><code>10APR18 [in between text] 11JUL18 [in between text] etc.
  </code></pre>
  
  <p>I'm not too familiar with the needed syntax, but I'd guess it would something all the lines of extracting everything after:"(number)(number)(letter)(letter)(letter)(number)(number)" up to "Base"</p>
  
  <p>If anyone could shed some light on a solution or point me in the right direction, I'd be incredibly grateful. Thanks!</p>