I am importing a text file from the mainframe in which the last
field of the record is spaces. After transfer of the file down to my
PC as a text file, I then wish to import it into Excel.
Excel is truncating the last column and wiping out my record length
which needs to be a fixed record length. After user corrections,
the Excel file will then be formatted back to text and processed
by another PC application. Any suggestions on how to prevent
the truncation of the last column of my records?
Thanks!
Bookmarks