title: Extract line within a cell
body: <p>I have information in a cell that i would like to extract only certain portion of it. There are lines within a cell seperated by a CR.</p>
  
  <p>Eg. :</p>
  
  <pre><code>This is line 1
  This is line 2
  How Are you??
  That is line 3
  ---------------------------
  this is line 4
  that is line 8
  I want this line too
  </code></pre>
  
  <p>The above are all within a cell. And I would like to extract only line that DO NOT start with THIS or ----- or How</p>
  
  <p>That is line 3
  that is line 8
  I want this line too</p>
  
  <p>So when i run the VBA or macro i would end up with 3 lines. </p>
  
  <p>Each sentence is not constant. I.e. it could be any length of words, but the first word of those that i want to truncate away is constant, i.e. starts with either This or That. Those that I want to keep is usually not constant as it's an open field keed in by users. </p>
  
  <p>So i want to truncate away lines starting with --- or This or That, but keep anything else.</p>
  
  <p>And this is for a whole range of cells, eg. from A1 to A100.</p>
  
  <p>Hope the info i have provided is sufficient.</p>
  
  <p>cheers
  jeffery</p>