asked on

How to preserve commas in CSV file when saving the file in Excel 2010

Hi experts
I've problem in preserving the commas in a CSV file when I try to save the file by Excel 2010.
The csv files are attached. Thanks in advance.

Before saving:
Settings,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,Description,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
1, 2, 3, 4,5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17,18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33,,,,,,,,,,,,,,,,,,,,

After saving by Excel 2010:
Settings,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,Description,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33
original.csv
saved2010.csv

Dave Baldwin

It looks to me like it is saving on the area where there is content. If you want it to save all of those blank columns, you need some content in the last column to the right.

dominicwong

ASKER

Thanks Dave.
The empty columns are for future expansion so they are blank for the moment.

Or, is there any characters that I can insert and they don't get displayed in Excel 2010?

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION