fixed width and delimited

  1. Z

    Need to convert from Excel to text file fixed width, space delimited other than .prn

    I have an Excel file that I need to convert to a fixed width, space delimited text file, however when I tried converting to a .prn file it is wrapping the columns that exceed 240 characters per line. It has to text file with padded spaces or fixed width columns. What other format can I use...
  2. S

    Importing Text data using fixed width and delimited

    Hi, I'm trying to import data from a .txt file http://www.4shared.com/photo/2fda9qRj/TXT1.html The condition is it needs fixed width + delimited with "." but I end up having it in this format. http://www.4shared.com/photo/FUoi3tn4/Excel1.html What I want is to keep it completely in Column...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top