Excel: Text File Opens Blank or with Partial DataLast reviewed: November 2, 1994 |
SUMMARYWhen you open a text file into Microsoft Excel, a blank worksheet may open, or only part of the file may appear. This will occur if the file contains an ASCII zero value. Excel uses an ASCII zero as its internal terminator. As soon as Excel encounters an ASCII zero when opening a text file, Excel stops reading the file. To remove the ASCII zero value, do the following:
MORE INFORMATIONTo remove ASCII zeros from a file using Word:
|
KBCategory: kbother Last reviewed: November 2, 1994 |