title: How can I merge text with different color formatting into one cell and keep the color formatting?
body: <p><strong>Data:</strong></p>
  
  <p>I have the following table: </p>
  
  <pre><code>160  89  85 116 161
  147 117 133 148 191
   93  91  94  92 107
  147 148 177 133 205
  116 147 117 190 148
  </code></pre>
  
  <p><strong>Problem:</strong></p>
  
  <p>I want to merge the data into a single column.</p>
  
  <p>The code for a single row, run through a button.</p>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>Sub mergeStuff()
      Range("M3").Value = CStr(Range("H3").Value) + "," + CStr(Range("I3").Value) + "," + CStr(Range("J3").Value) + "," + CStr(Range("K3").Value) + "," + CStr(Range("L3").Value)
  End Sub
  </code></pre>
  
  <p><strong>Output example:</strong></p>
  
  <pre><code>    160,89,85,116,161
      147,117,133,148,191
       93,91,94,92,107
      147,148,177,133,205
      116,147,117,190,148
  </code></pre>
  
  <p><strong>Question:</strong></p>
  
  <p>The numbers are formatted. They have different colors. How can I merge in one cell and keep the color formatting?</p>