Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Unanswered: Exporting to a .txt file

    Is there any way to export an Excel file to a .txt where all the columns line up (meaning all fields start in the same column). When I save as a .txt it shifts everything over so the fields start in different columns. I am using excel 2003.

  2. #2
    Join Date
    Apr 2004
    Derbyshire, UK
    Provided Answers: 1

    I tried saving as both

    Unicode Text (*.txt)
    Text (tab delimited) (*.txt)

    and both seem to retain its column spacing !!?


  3. #3
    Join Date
    Nov 2007
    If you do a 'savesas' and choose the first 'text type' it will create a tab delimited file. This means that at the boundary of each cell it will insert a tab character. When you look at the resulting file using a text viewer (like notepad) these tab characters will make it look like the columns don't line up.

    Have you tried to 'saveas' a 'formatted text' file (aka space delimited)? This will give you an output file that makes all the cells in the same column equal in size. It will fill in with extra spaces to make everything line up.

    Keep in mind though that if you use a program like notepad to look at your text file you may still see jagged columns. If this is the case then try setting the viewing font in notepad to a fixed width font like Lucida Console.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts