Friday, March 4, 2016

Tech Support: converting fixed width excel file into text file

converting fixed width excel file into text file

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

Anwsers to the Problem converting fixed width excel file into text file

Download SmartPCFixer to Fix It (Free)

See
http://dailydoseofexcel.com/archives/2008/02/28/fixed-width-text-files/

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Repair the Problem: converting fixed width excel file into text file:

 

 

How to Fix converting fixed width excel file into text file with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: Performance Issues Since I Updated To Windows 7,How To Install All The .net Frameworks?,How To Preview A File In The Recycle Bin,My Windows Dose Not Permit Internet Explorer 8, 9 And Yahoo Messenger To Perform Corretly ,,Programs Gone After Hard Drive Replaced,Windows 8 BSOF: System Service Exception,Summing Hours:minutes In PivotTable,Error Message When I Exit Programs.,Laptop Frozen In Logging Off Phase, What Can I Do To Just Restart This Laptop!,I Would Like To Change The Default Cell Background Color And Save It In My Toolbar.Its Yellow Now, I Would Like It To Be Green.
Read More: DRIVER_IRQL_NOT_LESS_OR_EQUAL (kbdclass.sys) on Windows 8.1,Frequent Blue Screen @ random times-Time for full reinstall of Win 7 64 Ultimate???,how do i remedy,ITunes error "'application failed to start because it's side by side configuration is incorrect",Computer performance is very slow,parallels transport agent for windows 7

No comments:

Post a Comment