I am facing a problem while saving a CSV file from Excel. The problem is
as follows:

I have a CSV file with 1st row having 20 columns and the rest of the
rows having data in first 16 columns and next four columns are empty.
So when I am creating a CSV file in notepad/textpad, the last 4 columns
are represented by 4 commas (',').

Then I am opening the CSV file in excel and using the save as option, I
am saving it with a new name. The new file when opened in
textpad/notepad, the 4 commas are appearing only till first 16 rows.
from 17th row onwards, the trailing 4 commas are not appearing.

I need those commas since they represent empty columns. otherwise the
program which is accepting the csv file will generate error.

I am attaching the original CSV file and the CSV file saved using excel
for your reference.

Please help.

Thanks in advance


--
meeta das
------------------------------------------------------------------------
meeta das's Profile: http://www.excelforum.com/member.php...o&userid=31559
View this thread: http://www.excelforum.com/showthread...hreadid=512540