title: Copying Excel Cell and retaining Line Breaks
body: <p>I am generating a HTML email template using Excel to save time.</p>
  
  <p>Essentially B2 contains the Header
  eg </p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;&lt;/head&gt;
  &lt;body&gt;
  &lt;table&gt;
  </code></pre>
  
  <p>B3 contains various sections that are populated using excel cell data
  EG </p>
  
  <pre><code>&lt;tags&gt;stuff&lt;/tags&gt;
  &lt;tags&gt;stuff&lt;/tags&gt;
  </code></pre>
  
  <p>B4 also contains a section of html populated using excel data</p>
  
  <p>B5 contains the footer.
  eg</p>
  
  <pre><code>&lt;/table&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>B6 then creates the full html document using the formula =B2&amp;B3&amp;B4&amp;B5</p>
  
  <p>Now if I copy the cell B5 and paste into notepad, it will strip the line breaks and look something like this:</p>
  
  <pre><code>&lt;/table&lt;/body&gt;&lt;/html&gt;
  </code></pre>
  
  <p>I can keep the linebreaks intact by double clicking this cell and copying the data.</p>
  
  <p>However, because B6 contains a formula, i cannot double click on this cell to copy the data as it will revert to the formula. If I copy the entire cell, all linebreaks are removed.</p>
  
  <p>eg</p>
  
  <pre><code>&lt;html&gt;&lt;head&gt;&lt;/head&gt;&lt;body&gt;&lt;table&gt;&lt;tags&gt;stuff&lt;/tags&gt;&lt;tags&gt;stuff&lt;/tags&gt;&lt;/table&lt;/body&gt;&lt;/html&gt;
  </code></pre>
  
  <p>So the question is, how can I copy cell B6 while retaining all line breaks?</p>
  
  <p>Cheers</p>
  
  <p>Ryan</p>