How to Add single Quotes and Comma in Excel with CONCATENATE Function

In Microsoft Excel, you can use the CONCATENATE function to combine text strings, and if you want to add single quotes and a comma between the text, you can include them as additional text arguments within the CONCATENATE function. Alternatively, you can use the "&" operator to concatenate strings. Here's how you can do it with both methods:

By Using CONCATENATE Function

For this you need to write the formula like this,

=CONCAT (“‘“, A2,”‘”,”,”)

• First you create a column and select the first cell. 
• Type =CONCAT ( Write the formula =CONCAT (“‘“, A2,”‘”,”,”) like this. 
• Where A2 is the first cell value of your employee code.

You can use CONCATENATE Function for different scenarios, one of the benefit using this function is , you can use many texts without any limit, you can use comma insie the function and can add many texts.

By Using & Operator

Alternatively, you can achieve the same result using the "&" operator:

This formula you can use for the same thing— adding single quotes and comma in excel with & Operator. Choose the method that you find more convenient or readable. Both formulas will give you the desired result.

...

=”‘“&A2&”‘”&”,”

...

• First you create a column and select the first cell. 
• Type = Write the formula =”‘”&A2&”‘”&”,”  like this. 
• Where A2 is the first cell value of your employee code.

Conclusion

For accomplishes the task , you can use above two methods, both are simple and you can get the desired results. the recommented method is usinng CONCATENATE function, which is standared and easy to understand.