MS Excel: Adding quotes round text for .csv export

Just a quick one this.  When exporting columns of text for .csv files you will probably want to have the text blocks encased in double quotes.  To do this in excel, before saving as .csv, simply

  1. highlight the cells you want to quote-up
  2. right-click on them and choose “format cells”
  3. choose custom from the “Category” list (under the number tab)
  4. in the “Type” box type the following:   \”@\”
  5. hit ok

The backslash is the escape character used to say “use the symbol that comes next” and the @ can be considered to be the wildcard or placeholder for the current contents.

Saves having to use your code/text editor to add in all the quotes.

Facebook Comments

Leave a Reply

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

Apply your human brain cells and complete this highly complicated maths problem *