OT: Adding " in Excel cells?

Throughout an excel document we want to have any data which is in any
of the cells enclosed within double quotes ready for outputting/saving
as CSV file so that the eventual format is like this:

"some text","some other text","some more text and maybe a
hyperlink","etc","etc"

At the moment the cells are all populated with a mix of dates, text,
etc but with no " " around it. I have tried using the substitute tool
but to no avail - I think I may be doing it wrong!

why re-invent the wheel
Use Excel to "save as" csv file and the job is done for you
HTH

Why bother with quoting numbers. IME of converting huge quanties of
CSV data, the biggest issue comes parsing quoted text with quote marks
and commas embedded in them[1]. I had to write my own parser in the end.

Furthermore different versions of spreadsheet programs export csv data
in slightly different ways.

That's why I prefer TAB delimited text if possible.

Aye. The other annoyance is line breaks in quoted text cells.

For human readabily, we prefer the humble tilde character as a
seperator.

DAMHIK,IJD,OK?

Things have moved on these and there will be stuff out there, I imgine.

[1] MS Double quote qotes when exporting them.[2]
[2] Parse this: 1,2,"","""Hello, ""Sailor""",3.14

add in a single quote ' at the beginning.

Ta in advance