title: Extracting data before specific character
body: <p>I have number of data which has dates and time in a cell sometime there are multiple dates and time value in the cell sometimes 1, 2, or more.</p>
  <p>So i have been trying to extract the dates and my formula is working fine but does not extract the other dates except single/first available in the cell.</p>
  <pre><code>=LEFT(A2,(FIND(&quot;-&quot;,A2,1)-1))
  </code></pre>
  <p>Any help will be appreciated.</p>
  <p><a href="https://i.stack.imgur.com/KQQRO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KQQRO.png" alt="enter image description here" /></a></p>