+ Reply to Thread
Results 1 to 3 of 3

Save as Text (tab delimited) problem

  1. #1
    Prema
    Guest

    Save as Text (tab delimited) problem

    My spreadsheet has data in column A,B and D C is always blank. My saved file
    looks as below:

    111111 -1234.00 GBX020H44A
    111111 1234.00 GBX020H44A
    222222 100.00 GBX020H44A
    222222 -100.00 GBX020H44A
    333333 12345.00 GBX020H44A
    333333 -12345.00 GBX020H44A

    I would like each column to be aligned but it looks as though as soon as I
    exceed 7 characters in column B everything gets pushed. What can I do to keep
    it aligned?

    Prema

  2. #2
    Tom Ogilvy
    Guest

    Re: Save as Text (tab delimited) problem

    Save it as formatted text space deliminted (.prn)

    --
    Regards,
    Tom Ogilvy


    "Prema" <Prema@discussions.microsoft.com> wrote in message
    news:BE7246C1-CB28-4E21-B7A3-D974E19DF5FC@microsoft.com...
    > My spreadsheet has data in column A,B and D C is always blank. My saved

    file
    > looks as below:
    >
    > 111111 -1234.00 GBX020H44A
    > 111111 1234.00 GBX020H44A
    > 222222 100.00 GBX020H44A
    > 222222 -100.00 GBX020H44A
    > 333333 12345.00 GBX020H44A
    > 333333 -12345.00 GBX020H44A
    >
    > I would like each column to be aligned but it looks as though as soon as I
    > exceed 7 characters in column B everything gets pushed. What can I do to

    keep
    > it aligned?
    >
    > Prema




  3. #3
    Gary''s Student
    Guest

    Re: Save as Text (tab delimited) problem

    In addition to Tom’s suggestion, you can always force a specific format in
    the same fashion as printing:

    Outside of Excel, define a new printer
    1. Tell the wizard it’s a local printer
    2. Make the port FILE
    3. Manufacturer if GENERIC
    4. Printer is TEXT ONLY
    (If you output to the printer, it will ask you for a file name)

    If you print the cell set (rather than SaveAs), the file will exactly follow
    your alignment instructions. In addition, PrintPreview will quickly allow
    you to make adjustments.

    --
    Gary''s Student


    "Tom Ogilvy" wrote:

    > Save it as formatted text space deliminted (.prn)
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "Prema" <Prema@discussions.microsoft.com> wrote in message
    > news:BE7246C1-CB28-4E21-B7A3-D974E19DF5FC@microsoft.com...
    > > My spreadsheet has data in column A,B and D C is always blank. My saved

    > file
    > > looks as below:
    > >
    > > 111111 -1234.00 GBX020H44A
    > > 111111 1234.00 GBX020H44A
    > > 222222 100.00 GBX020H44A
    > > 222222 -100.00 GBX020H44A
    > > 333333 12345.00 GBX020H44A
    > > 333333 -12345.00 GBX020H44A
    > >
    > > I would like each column to be aligned but it looks as though as soon as I
    > > exceed 7 characters in column B everything gets pushed. What can I do to

    > keep
    > > it aligned?
    > >
    > > Prema

    >
    >
    >


+ 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