Saving as CSV
Posted by Andy D. on December 15, 2000 1:11 PM
I have some spreadsheets that I have to save into CSV format for importing into another program. What I do is hightlight all of the data and make a print area (ie. A1 to Q41) and there are no empty rows or columns. I then do "save as" and pick *.csv and when I open the file in a text editor (edit.exe), there are 2 rows of extra commas at the bottom. Is this a know problem or is there any way to prevent this from happening?