title: Concatenate in excel with special characters
body: <p>This is my excel table </p>
  
  <pre><code>state      City Name    area type
  GUJARAT    Abdasa       City
  GUJARAT    Adalaj       City
  GUJARAT    Ahwa         City
  </code></pre>
  
  <p>I want to create this(in the row next to area type of course)</p>
  
  <pre><code>('GUJARAT','Abdasa','City'),
  </code></pre>
  
  <p>For that I have tried following formulas</p>
  
  <pre><code>=CONCATENATE("('"+A2+"','"+B2+"','"+C2+"'),")
  =CONCATENATE("('" &amp; A2 &amp; "','" &amp; B2 &amp; "','" &amp; C2 &amp; "'),")
  </code></pre>
  
  <p>I don't know much about Excel is this possible?</p>