Concatenate function in Excel 2010 to add single quotes and commas

Follow the below steps.

1- select all the rows.

2- right click and select format cells

3- select number tab

4- select custom in the left category tab and

5- under the type enter '@' (if column has hello after applying format it will turn into 'hello')

Try the following as an alternative to =concatenate():

="'"&A1&"',"

I've been using the above to do exactly what you're trying to accomplish.