ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel CSV file format issue... (https://www.excelbanter.com/excel-discussion-misc-queries/23859-re-excel-csv-file-format-issue.html)

Duke Carey

Excel CSV file format issue...
 
Just confirmed it on Excel 2002 / Win2k

Sure *seems* like a bug


"netjim66" wrote:

Scenario: You have two columns in Excel. ColumnA contains 20 or so items, and
ColumnB only contains 1 item.
If you save it as a CSV file and view it in NOTEPAD or some other text
editor, the commas will stop being applied after the 16th row:

ColumnA,ColumnB
123455,0
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455,
123455
123455
123455
123455
123455
123455

Which makes it useless really if you are using another program that reads
comma-delimited files.

Is this a Bug?

Any ideas?



All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com