title: Inserting semicolon in between data in a cell in Excel
body: <p>I have data in column A, C, E and G. I want column I to hold all of the data from these separated by semicolons, I have searched the web but all I find is how to replace line breaks with semicolons and that doesn't do it. Below are the 3 pieces of code I have attempted to work into it</p>
  
  <pre><code>Range("I" &amp; i).Value = "=A" &amp; i &amp; Chr(59) &amp; "&amp;" &amp; "C" &amp; i &amp; "&amp;" &amp; "E" &amp; i &amp; "&amp;" &amp; "G" &amp; i
  Range("I" &amp; i).Value = "=A" &amp; i &amp; "&amp;C" &amp; i &amp; "&amp;E" &amp; i &amp; "&amp;G" &amp; i
  Range("I" &amp; i).Value = Range("A" &amp; i).Value + ; + Range("C" &amp; i).Value + ; + Range("E" &amp; i).Value + ; + Range("G" &amp; i).Value
  </code></pre>
  
  <p>The second line comes closest to what I want but when I add &amp; ";" into it I get errors.</p>
  
  <p>Any ideas thoroughly appreciated</p>
  
  <p>SOLVED : This was solved by an answer below, I had managed my own fix which I will detail but the accepted answer is a cleaner, more efficient way</p>
  
  <p>mystring = "=A" &amp; i &amp; "&amp;" &amp; Chr(34) &amp; ";" &amp; Chr(34) &amp; "&amp; C" &amp; i &amp; "&amp;" &amp; Chr(34) &amp; ";" &amp; Chr(34) &amp; "&amp; E" &amp; i &amp; "&amp;" &amp; Chr(34) &amp; ";" &amp; Chr(34) &amp; "&amp; G" &amp; i
      Range("I" &amp; i).Value = mystring</p>