Saving as CSV with double quotes

Originally Posted by Aardigspook

If you don't mind having non-straight double quotation marks, then you can use CHAR(147) / CHAR(148) / CHAR(152)

Formula:

=CHAR(147)&"content"&CHAR(148)

will give “content”

Formula:

=CHAR(152)&"content"&CHAR(152)

will give ˜content˜

Is that something you can work with?

Hi Aardigspook,

Unfortunately I need it to be straight double quotation marks, as I will use it elsewhere as a text qualifier. Unless non-straight double quotation marks will pass for normal quotation marks in general terms.