Saving as a CSV

[neilp]

Hi.
I have been asked to look at creating a CSV file and have been given the spec. that it needs to output like.

Straightforward enough - apart from the start.

The first 3 cells in every row are blank and need to just return the comma, yet when I save my excel as a CSV, then open it in notepad, it seems to start at the info that was in column D (yet all other columns that have no data get the comma inputted that i would expect)

Anyone know how to correct this?

thanks in advance

N

 

[Bosquedeguate]

If you put headers on the first row (before doing your Save As step) you should get commas for your empty cells.

 

[neilp]

Perfect - thank you