View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SRCC SRCC is offline
external usenet poster
 
Posts: 1
Default export excel to EBCDIC fixed-width text file

How do I convert a 40 column spreadsheet, containing both text and numeric
data, to a 200 field EBCDIC fixed width TXT file for uploading to a
mainframe? Output length = 1300. The additional 160 fields will be
defaulted to spaces or zeros. Several of the source columns will map to
signed numeric (S9(8)v99) fields.