saving excel to text files, formatting question?

[paul]

hello

the problems is i have to save an excel file to text file,
so that column A takes up the first 10 columns,
column B takes up 7 columns in the text file and so on ,

or word it in another way

each of the excel columns have to be placed at certain columns of the text
file
column a in excel takes up spaces 1to 7 in the text file
column b in excel takes up 8-12 in the text file
etc

how would i go about doing this in excel 2003
thanks paul!

 

[Bob I]

You will need to change the entire sheet to text and pad the short
entries to the desired length, OR Export to CSV, Import to Access,
Adjust the field size in "Design" and then Export to text.

 

[Beth Melton]

It sounds like you want a fixed width text file. If that's the case
then In Excel use File/Save as and saved as a "Formatted Text (space
delimited) (*.prn)" file.

The resulting text file will utilize the column widths to determine
starting/ending positions for each column. Once you've saved the file
you can simply change the file extension to .txt if you'd like.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/