Adding comma or single quotes for all the rows in the column excel

If you want to add a comma or single quote or both you can add easily using the below excel formula’s

1. Adding comma to all the rows of a column:
Formula:
=””&A3&”,”

2. Adding single quotes to all the rows of a column:
Formula:
=”‘”&A3&”‘”

3. Adding comma and single quotes to all the rows of a column:
Formula:
=”‘”&A3&”‘,”

Thanks for reading this post…!
Add your comments in the comment area…!!