comma delimited & surrounded by quotes
Unfortunately, to get quotes you need to actually embed them in the file,
save it as a text file, and then rename it to a csv.
If your example numbers are in row 1, in columns A-E, then in F1 use the
formula:
=""""&A1&""","&""""&B1&""","&""""&C1&""","&""""&D1 &""","&""""&E1&""""
copy it down as far as you need, then select all the formulas, press Ctrl-C
to copy them, then Edit-Paste Special-Values to replace the formulas with
the results. Then delete columns A-E and save the file as text
"Rk" wrote:
hi , does anyone know how to out put data from a excel spread sheet so it is
in the following format
in spreadsheet 1 2 3 4 5
output
"1","2","3","4","5"
tried .csv but that is just 1,2,3,4,5
--
thanks
|