title: Identify pattern and extract substring
body: <p>I have thousands of rows in Excel where inside random text there are periods like &quot;31.12.2019-30.12.2020&quot;.<br />
  I need to extract this substring from each row and put it in a separate cell.<br />
  The substring always has the same pattern but the text is different and it can be anywhere within the text.</p>
  <p>Is it possible with a formula or through VBA to identify this pattern: &quot;XX.XX.20XX-XX.XX.20XX&quot; and then return the substring?</p>
  <p>I couldn't find a formula through Google.</p>
  <p><a href="https://i.stack.imgur.com/oD7EW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oD7EW.png" alt="enter image description here" /></a></p>