I am trying to take a text file exported from a mainframe system, edit it in
excel, then import it back to the mainframe. All spaces are significant, but
whether I parse the file by fixed width directly from the text file or by
using Text to Columns any spaces that start or end a column are lost. Also,
if the entire column consists of spaces they are not brought in.
Is there a setting I can use to force the spaces to carry over?
Thanks in advance for any assistance.
ed