Hello,
I am working with some text files created in DOS that are in a space
delimited format. I am trying to import the file into Excel, perform updates
and then export back to a text file. Importing is no problem. Making the
updates has been no problem. What has caused me problems is the 'save as'
portion of the process. I have chosen .prn for a space delimited file but am
having trouble formatting the worksheet so that the text displays correctly
(one space between columns). Does anyone have any advice?

Tom,

"Space delimited" is a misnomer. It's really "Space padded." There may be
lots of spaces. Take a look at
http://www.smokeylake.com/excel/textfiles.htm. Read Space Delimited (prn).
See if that helps.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Tom J." <Tom wrote in message
...
Hello,
I am working with some text files created in DOS that are in a space
delimited format. I am trying to import the file into Excel, perform
updates
and then export back to a text file. Importing is no problem. Making the
updates has been no problem. What has caused me problems is the 'save as'
portion of the process. I have chosen .prn for a space delimited file but
am
having trouble formatting the worksheet so that the text displays
correctly
(one space between columns). Does anyone have any advice?