apply single tick mark before and after concatenated values in single cell
<p>I would like to combine single tick marks before and after concatenated values in excel.  Ultimately i need this to be passed into a SQL query</p>

<pre><code>EX: 

Before--&gt;pig, dog, bird, cat   cell A1

After--&gt;'pig','dog','bird','cat'    cell A2 

Used For:

WHERE
a.Type IN ('pig','dog','bird','cat')
</code></pre>