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&”,”

adding comma

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

adding single quotes


3. Adding comma and single quotes to all the rows of a column:

Formula:
=”‘”&A3&”‘,”
adding both

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

1,823 total views, 6 views today

Leave a Reply

Your email address will not be published. Required fields are marked *