ExcelBanter - csv files - size restriction

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - csv files - size restriction (https://www.excelbanter.com/excel-discussion-misc-queries/4256-csv-files-size-restriction.html)

Rubble

csv files - size restriction

I have csv file with approx 24000 rows in it but when I view it in Excel 2003
only 23500 rows are displayed.

Dave Peterson

Just a guess---

Maybe when you viewed the .CSV file to see 24000 rows, you saw long lines
wrapped.

So it looked like more lines were actually there.

Does the last line in the text file match up with the last row after the import?

Rubble wrote:

I have csv file with approx 24000 rows in it but when I view it in Excel 2003
only 23500 rows are displayed.

--

Dave Peterson

All times are GMT +1. The time now is 06:59 PM.