Text file import skips blank rows

P

PaulB

I have a report that was pruposely formatted to insert a blank row at every change in supplier or PO #. This report always imported into Excel 2000 properly. Excel 2003 skips the blank rows forcing me to insert them manually. Is there any way to turn this feature on (or off)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing text file skips blank rows 0
CSV Data/Import Issues 1
Why does the skip blanks (paste special) function not work? 2
numbering rows, but skipping blanks 9
Populate cell with multiple non-blank text values 4
VBA - (re-) Set a Table Style 2
.csv Saved File Question 1
Inserting blank rows in Excell 4

Top