title: Maintain line breaks with cell when assigning value to html table
body: <p>I am generating a html email which contains a table of certain values from an excel worksheet based on flag values. The problem I'm having is that some cells contain line break in them, for example:</p>
  
  <p>In cell B5, a user has entered:  </p>
  
  <pre><code>Red
  Blue
  Green
  </code></pre>
  
  <p>With a line space between each word.</p>
  
  <p>I am using</p>
  
  <pre><code>&lt;html&gt;
      &lt;table&gt;
          &lt;tr&gt;
              &lt;td&gt;Cells(5,2).Value&lt;/td&gt;
          &lt;/tr&gt;
      &lt;/table&gt;
  &lt;/html&gt; 
  </code></pre>
  
  <p>this returns:</p>
  
  <p><code>red blue green</code></p>
  
  <p>in one row within the table cell. What I want is the text wrapped over 3 rows within the one table cell:</p>
  
  <pre><code>red
  blue
  green
  </code></pre>
  
  <p>Other cells in the same row might only contain a single value so adding extra rows isn't really the solution I'm after.</p>
  
  <p>How do i retain the line breaks that were initially entered into the cell when assigning the value to the html table in an email?</p>