title: Clear the cell content before the keyword
body: <p>I'm trying to clear the data before the keyword <strong>TRUE</strong> including blank cells in between, and also I don't want to hardcode the range because the range will keep on change. can anyone please help me with this.</p>
  <pre><code>A
  1
  2
  3
  4
  5
  
  3
  4
  
  
  53
  
  53
  
  TRUE
  </code></pre>