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
- highlight the cells you want to quote-up
- right-click on them and choose “format cells”
- choose custom from the “Category” list (under the number tab)
- in the “Type” box type the following: \”@\”
- 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.