Microsoft KB Archive/77295

= Column delimiters missing in spreadsheet saved as text =

Article ID: 77295

Article Last Modified on 7/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 3.0 for OS/2

-



This article was previously published under Q77295



SYMPTOMS
In Microsoft Excel, if you save a file in the text or the CSV (comma separated value) format, Microsoft Excel places tabs or commas between each column of the worksheet. However, certain text files may be saved with a different number of tabs or commas in 16-row blocks.



CAUSE
This behavior occurs only if the cells in the last column contain no information.



WORKAROUND
To ensure that Microsoft Excel saves tab or comma delimiters for all empty columns, verify that the last column in the file contains some data in at least every 16 rows throughout the file. If the blocks of rows do not contain data, add spaces or other characters in every 16 rows to the cells in the last column or reorder the columns in the worksheet so that the last column on the worksheet always contains information.



MORE INFORMATION
Microsoft Excel saves text files in 16-row blocks. Therefore, if all the cells in the last column in a 16-row block are empty, Microsoft Excel saves that area as if the column does not exist. No tabs or commas are saved for that 16-row block.

Additional query words: 3.0 null 15 XL

Keywords: kbbug KB77295

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.