Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delimited Text File (Office XP)

    Is it possible to export the workbook into a delimited format which will not show the column headings? I have attached a dummy sample . Or any other suggestions to convert a Excel workbook into a text file.

    Thanks, kun

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delimited Text File (Office XP)

    In the example you attached, delete the first 8 rows, then save as a text file. The original workbook will not be affected.

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    Hans ,

    Thank you assisting. Err.. the end result is not what I want. I have attached another dummy 's which is in the format that I want.

    thanks. kun

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Delimited Text File (Office XP)

    Just to straighten this out. Are you wanting the exported txt file to ONLY contain titles, or ONLY the data. There is a little ambiguity about your request!
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delimited Text File (Office XP)

    The dummy file has row and column headings, sheet tabs and grid lines hidden. Those elements won't be exported to a text file anyway.

    You have a "company logo" in the dummy file. Graphics won't be exported to a text file at all, a text file contains only, uh, text.

    If you want to preserve some of the formatting, you don't want a delimited text file, as mentioned in your subject, but a fixed width text file in which the values are padded with spaces (*.prn).

  6. #6
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    Hi Hans and Rudi,

    Thank you for your response. I want the format which show the graphics and the data on a workbook basis, exactly the same as my dummy sample, maybe a fixed width file which Hans mentioned. Is this possible?

    thanks, kun

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delimited Text File (Office XP)

    No. A text file only contains plain text, NO formatting and NO graphics. If you want formatting and graphics, just copy the workbook, or create a PDF file (you need special software for the latter)

  8. #8
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    Hans,

    Thank you for your reply. You means the dummy sample is actually a formatted copy of an Excel file. Therefore, if I want something like this, I will need to copy and paste into a new workbook / sheet right?
    How do I hide the column and rows?

    cheers, kun

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    Tools/Options, View Tab. Turn off Gridlines and Row & Column Headers.

    What you posted is a .xls file, which is an Excel file, not a text file.
    Legare Coleman

  10. #10
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    Legare,

    Thanks for the tip, but the file that I posted can't calculate and I need to do a delimited to convert it into a calculable spreadsheet, therefore I thought it is a text file in Excel. I think maybe I understand now.

    thanks, kun

  11. #11
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delimited Text File (Office XP)

    I'm not sure what you mean by "can't calculate." If you mean that you can't enter a formula in any cells and have it calculate, that is because all of the cells in the worksheet are formatted as Text. If you select a cell, change the format to General, then you can enter a formula that will calculate. You will have to do the same for any cells that you want to enter numeric values into.
    Legare Coleman

Posting Permissions

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