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,603 total views, 1 views today

About Mirthbees 672 Articles
Blogger, Innovator, Developer and Enterpreneur. Founder of GuruRecharge, Readymade online recharge script. Lead Developer in Bookrate.in

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.