title: How do you extract the first sentence in Excel
body: <p>I have around 2000 descriptions that need a short description. Here is an example of a description.</p>
  
  <p><strong>Chloe New, the heir of the Original Chloe is warm, feminine and a great signature scent. Chloe is a flowery scent with peonies, freesia, magnolia, lilies and rose petals along with ripe litchis. A hint of woods at the base makes Chloe New the best everyday fragrance. It's long lasting power keeps you fresh all day long.</strong></p>
  
  <p>The result being this</p>
  
  <p><strong>Chloe New, the heir of the Original Chloe is warm, feminine and a great signature scent.</strong></p>
  
  <p>Sometimes other descriptions will end like this, for example:</p>
  
  <p><strong>Chloe New, the heir of the Original Chloe is warm, feminine and a great signature scent. Chloe is</strong></p>
  
  <p>The current function I am using is the "=left(a1,70)" which takes the first 70 characters starting from the left. However, this function doesn't always extract the first sentence but ends at the beginning of the second sentence.</p>
  
  <p><br /><br />
  So my question is:</p>
  
  <p>Is there a function that only extracts the first sentence of a cell?</p>