If the last column is always the same number of spaces you could set it as
=rept(" ",9) or however many spaces you need
if it is variable but you can calcualte however many you need by the other
cells
try something like
=rept(" ",50-len(A1)-Len(B1)-len(c1)) etc.

"Ttown" wrote:

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!