Share via

converting fixed width excel file into text file

Anonymous
2013-04-01T02:58:52+00:00

hi, 

i'm trying to convert fixed width excel file into text file using .prn formatted. however, .prn files will only cater up to 240 characters per line. Anything more than 240, it will truncate to the next line.

since my excel data consist more than 240 characters per line, so any ideas on how to convert it into text file.

link below is the sample excel file that i need to convert.

https://skydrive.live.com/redir?resid=DB0C4EF8AADC13AC!107&authkey=!AOWK-WddjzN2TRM

please help..

thanks,

regards

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-04-03T04:31:49+00:00

    link that you give, help me a lot.. 

    thanks.

    regards,

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-04-01T05:11:48+00:00

    Hi,

    thanks for reply.

    i need to keep the size of data/columns.. TEXT or CSV type is not working for this. do you have any other options? since my system only cater for text file only.

    thanks,

    regards

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-04-01T04:30:51+00:00

    Open the file in Excel.

    Choose Save As and either choose TEXT or CSV options... click YES on the prompts.

    Open the file you have saved in Notepad or any other Text Editor you have. Try to save in differenct formats and see the difference when you open in Notepad. Choose the one which meets your requirements.

    Was this answer helpful?

    0 comments