How to Export Excel 2010 to fixed width text file
This tutorial will demonstrate how to export data from Excel to a fixed width text file
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
/ ithowtovids - our feed
/ howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+
In this tutorial you are going to learn how to export excel to fixed width text file so it is easily viewable even by people who don't have access to Excel.
Step # 1 -- Selecting Save As
Generally when you export an Excel file to text it will not keep the widths that you have defined in excel. In the spreadsheet here you can see that the "Share" column is larger than the other two and this is a width that we want to "fix" in the exported file. Click on the "File" button in the top left corner of the screen, from here click on the "Save As" option.
Step # 2 -- Saving as a .prn File
The "Save As" window will appear. You don't want to save as a regular text file but instead as a "*.prn" file. Click on the "Save as type" drop down list and click on the "Formatted Text (Space Delimited)" option. Click "Save". Click "Yes" in the dialog box that appears. That is essentially how to export excel to fixed width text file.
Step # 3 -- Selecting Save As
Now, to make sure that the column space has been exported into the text file, you are going to need to open it. Navigate to where you saved the file and open the document with Notepad. Here you can see that the spacing has been kept the same as in the original spreadsheet.
Watch video How to Export Excel 2010 to fixed width text file online without registration, duration hours minute second in high quality. This video was added by user Excel, Word and PowerPoint Tutorials from Howtech 17 January 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 58,77 once and liked it 4 people.