title: How to add single quote and comma to all values in a column?
body: <p>I have a column <code>host</code> with following values:</p>
  
  <pre><code>server1.abc.com
  server2.abc.com
  server3
  </code></pre>
  
  <p>Now, I want each of these values to be single quotes and separated by comma. The output should be like as below:</p>
  
  <pre><code>'server1.abc.com','server2.abc.com','server3'
  </code></pre>
  
  <p>Please let me know how this can be achieved using Excel.</p>
  
  <p>So far I am able to separate values using <code>,</code> with following code:</p>
  
  <pre><code>Public Function MergeME(r As Range) As String
    MergeME = Join(Application.Transpose(r.Value), ",")
  End Function
  </code></pre>
  
  <p>How can I add double quotes around values in each cell??</p>