Exporting from Excel

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create fixed length cells & rows in excel as space delimited .prn 1
Drag text file to Excel -- stopped working 5
Import External Data 1
save Excel file to *.prn file 2
Converting an Excel file to Fixed Width 3
Saving As. . PRN file problem broken up columns.. 1
How do I prevent a long string of text from wrapping in a text fil 1
Exporting from Excel to Space Delimited File 3

Top