+ Reply to Thread
Results 1 to 4 of 4

Save a file as a text file

Hybrid View

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Save a file as a text file

    I want to save an excel file as a tab delimite text file. But I found that the last column is always a tab. I don't want it. How can I do it?
    Thanks
    Last edited by zhshqzyc; 02-10-2011 at 03:16 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,806

    Re: Save a file as a text file

    This is not the behavior I see when I save tab-delimited files. Do you have actual blank data in the last column? Or is it completely unused? Can you post an example .xlsx file that causes this?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-20-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: Save a file as a text file

    For ex,

    1 2 3 4
    in excel becomes
    1\t2\t3\t4\t
    in the text file.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,806

    Re: Save a file as a text file

    I understand exactly what you mean. But when I do the same thing I do not get the final tab. I need to see your source file to see why it does this. I suspect there is blank data in column E.
    Last edited by 6StringJazzer; 02-10-2011 at 05:16 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1