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

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…!!

3,059 total views, 1 views today

Leave a Reply

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