Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104411

From BetaArchive Wiki

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.