View Single Post
  #1   Report Post  
ascii save
 
Posts: n/a
Default save an excel file in fixed length records whose fields are blank

I need to save the data in ascii format including fields that are fixed
length and have spaces in them. I have tried every save as type. Each column
is formatted to the column width of that field (10cpi). For example a last
name may be smith but that field is 15 characters long.Excel puts either a
space or tab between fields but does not retain the spaces. please help