title: Find and replace in Google Spreadsheet using Regular Expressions
body: <p>I would like to use the Google Spreadsheet Find and Replace function with the "Search using regular expressions" function activated to do a search and replace in my document. </p>
  
  <p>Use case: Some of my cells contain erroneous linefeed characters at the end (leftovers from paste operation by some of the editors).</p>
  
  <p>I'm using the following pattern to successfully find the cells</p>
  
  <blockquote>
    <p>.*\012$</p>
  </blockquote>
  
  <p>Is there some syntax for the "Replace with" field that lets me replace the cell's content by the string I found minus the <code>\012</code> character at the end?</p>
  
  <p>The Google Spreadsheet documentation does not contain any relevant information. <a href="https://support.google.com/docs/answer/62754?hl=en" rel="nofollow">https://support.google.com/docs/answer/62754?hl=en</a></p>
  
  <p><a href="http://i.stack.imgur.com/7AGz1.png" rel="nofollow">Here's a screenshot of the box</a></p>