Export an Excel spreadsheet to fixed-width text file?

Posted by jkohlhepp on Super User See other posts from Super User or by jkohlhepp
Published on 2010-01-25T19:02:42Z Indexed on 2010/03/20 9:21 UTC
Read the original article Hit count: 548

Filed under:

excel-2003

|

export

|

fixed-width

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.

Does it also have functionality where, given an existing spreadsheet, you can export to a fixed-width text file?

If so, how do I access this? I have tried using Save As and choosing Text File but it seems to only save as Tab-delimited which doesn't help me.

This is Excel 2003 if it matters.

© Super User or respective owner

Related posts about excel-2003

Migrating from VBA Excel 2003

as seen on Super User - Search for 'Super User'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Migrating from VBA Excel 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in… >>> More
Excel: how to add cells to named range

as seen on Super User - Search for 'Super User'
I have a named range for 3 cells in excel 2003 I need to insert 1 more cell into this named range how do I achieve this in excel 2003 >>> More
How to stop Excel 2003 from loading a Gazillion files

as seen on Super User - Search for 'Super User'
One of my soon-to-be-ex-friends got an Excel file from another friend of his and decided to click on it. It started opening all kinds of files from within Excel. Over 200 and still counting when he called me. I told him to go to task manager, which showed a LOT of files in the applications tab, but… >>> More
Create or Open an .xlsx file having >256 columns in MS Excel 2003

as seen on Super User - Search for 'Super User'
I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx). Now given that I have installed Compatibility pack, can I create or open a Microsoft Excel 2007 file (.xlsx) having more… >>> More

Related posts about export

how to concatenate two strings in shell script in 3.13.0-34-generic kernel

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I want to concatenate two strings for the shell file im getting error when i have created the shell file in following manner could you please suggest how to get it set export APP_HOME="/home/sfptladmin/ArchivalDaemon" export JAVA_HOME="/usr/lib/jvm/java-7-oracle/jre" export LIBPATH="/home/sfptladmin/ArchivalDaemon/lib" export… >>> More
How to do a "git export" (like "svn export")

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been wondering whether there is a good "git export" solution that creates a copy of a tree without the .git repository directory. There are at least three methods I know of: git clone followed by removing the .git repository directory. git checkout-index alludes to this functionality but starts… >>> More
Bash on Snow Leopard doesn't obey terminal colours

as seen on Super User - Search for 'Super User'
With the new version of Snow Leopard, OSX upgraded the bash version to GNU bash, version 3.2.48(1)-release (x86_64-apple-darwin10.0). Now, my .bashrc sets the following settings: # Colors export TERM=xterm-color export GREP_OPTIONS='--color=auto' GREP_COLOR='1;32' export CLICOLOR=1 export LSCOLORS=ExGxFxDxCxHxHxCbCeEbEb #… >>> More
Problem compiling hive with ant

as seen on Stack Overflow - Search for 'Stack Overflow'
I compiling with Solaris 10 SPARC, jdk 1.6 from Sun, Ant 1.7.1 from OpenCSW. I have no problem running hadoop 0.17.2.1 However, I have problem compiling/integrating hive with the error 'cannot find symbol', although I followed the tutorial. I have the hive source code from SVN exactly from tutorial… >>> More
Displaytag table exported header column contains span tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, When I export the content of the display tag table I use the data shows up fine, but the header cells are surrounded by html span tags, which is slightly annoying. I can imagine why Displaytag uses spans around the column header's text, but it shouldn't transpose in the exported data I think… >>> More