Microsoft KB Archive/104411

Microsoft Knowledge Base

Excel: How to Avoid Space Delimiter When Using Export Command

Last reviewed: September 12, 1996
Article ID: Q104411

The information in this article applies to:

• Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
• Microsoft Excel for OS/2, version 3.0
• Microsoft Excel for the Macintosh, versions 3.0, 4.0

When you use the Flat File add-in macro to to export a text file, the file retains the column width information and inserts a space as a delimiter between columns.

STATUS

This problem does not occur in later versions of Microsoft Excel for Windows.

WORKAROUND

If you want to export a text file without inserting this extra space, do the following to format the sheet with a monospace font (such as Courier):

1. Open the file you want to export.

2. From the File menu, choose Open. Switch to the LIBRARY subdirectory

       and open the FLATFILE.XLA file (the FLAT FILE file if you are using
       Microsoft Excel for the Macintosh).

3. From the Format menu, choose Style.

4. In the Style box, chose Define, and choose the Font button under

       Change.

5. In the Font dialog box, select Courier from the list of fonts.

6. In the Font dialog box choose OK, and choose OK again in the Style

       box.

7. Select the range of cells you want to export. From the Format menu,

       choose Column Width. Select the Best Fit button in the Column Width
       dialog box.

8. With the range of cells to export still selected, choose Export from

       the Data menu.

9. In the Export dialog box, enter the filename of the text file (if

       you don't specify a subdirectory here the file will be saved in the
       active directory), and clear the Retain Cell Formats check box.

10. Choose the OK button.

Microsoft Excel will export the file without adding a space-delimiter between columns.

NOTE: In the exported file, numbers will appear in text format. Therefore, numbers that were right aligned in Microsoft Excel will be left aligned in the text file.

REFERENCES

"User's Guide," version 4.0, page 152

KBCategory: kbusage KBSubcategory: Additional reference words: 3.00 4.00 4.00a flatfile xla delimited THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.