I need to export a list of dates from Excel of the form dd-mm-yy hh:mm to a .csv file where they have to be wrapped in double quotes. Like this
"31-12-2020 14:23"
This is turning out to be quite tricky. I tried the following:
a) Export as they are, and they appear in the csv file unwrapped.
b) Change them to text format - same thing. (Even though if you do the same thing with a list of words they do get wrapped in quotes)
c) I tried this:
=CONCATENATE(CHAR(34),TEXT(A1, "yyyy-mm-dd hh:mm"),CHAR(34)) - which wraps the date in cell A1 with double quotes.
Exporting this to a csv file ends up with the date wrapped in three sets of double quotes.
As a quick fix I then used the search and replace function but there must be a better way!
Can anyone help please?
"31-12-2020 14:23"
This is turning out to be quite tricky. I tried the following:
a) Export as they are, and they appear in the csv file unwrapped.
b) Change them to text format - same thing. (Even though if you do the same thing with a list of words they do get wrapped in quotes)
c) I tried this:
=CONCATENATE(CHAR(34),TEXT(A1, "yyyy-mm-dd hh:mm"),CHAR(34)) - which wraps the date in cell A1 with double quotes.
Exporting this to a csv file ends up with the date wrapped in three sets of double quotes.
As a quick fix I then used the search and replace function but there must be a better way!
Can anyone help please?