title: Merge contents of 2 Excel cells keeping character format intact (using VBA)
body: <p>As the title says: I try to merge the contents of 2 cells into a 3rd in Excel. There was a similar question <a href="https://stackoverflow.com/questions/621862/merge-the-contents-of-2-cells-into-another-3rd-cell-using-vba-in-excel">here on SO</a>, but those solutions do not keep the character format intact. For example, parts of the source cell contents are formatted bold and red, other parts are normal. When I merge them like</p>
  
  <pre><code> Range("A3") = Range("A1") &amp; Range("A2")
  </code></pre>
  
  <p>then any formatting of A1 and A2 is lost. What I need is a solution keeping the format intact. This is going to be part of a bigger VBA program, so I need a VBA solution, no formula, please. Excel version is 2002(XP).</p>