View Single Post
  #1   Report Post  
paul
 
Posts: n/a
Default excel formatting to text file

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!