title: Parsing data in Google Sheets
body: <p>I have customer data from PayPal formatted like this for their recurring payments:</p>
  
  <pre><code>john doe: john.doe@gmail.comCustomer ID: I-1ABCDE123ABCDescription: ABC 123
  </code></pre>
  
  <p>I want to parse this in a column to get just the email address.</p>