Saving as txt file

M

Mike Weiler

I was wondering if its possible/how to export an excel file to txt
format and make sure that the first column in excel will start be from
column 1-10 on a txt viewer and the second column would be from 11-20
in the txt viewer. If anyone could help me with this, I would really
appreciate it.
 
D

David Biddulph

Save As/ Space delimited text (*.prn)
but you may need some trial and error to get the width of your columns
right.
 
D

Dave Peterson

Check your other post.

Mike said:
I was wondering if its possible/how to export an excel file to txt
format and make sure that the first column in excel will start be from
column 1-10 on a txt viewer and the second column would be from 11-20
in the txt viewer. If anyone could help me with this, I would really
appreciate it.
Click to expand...
 

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

Excel file saved as txt with justified column numbers when viewed ina txt viewer 1
Export excel to txt with specified column placement 1
Exporting txt file 1
Converting excel file to tab delimited (txt) file 1
problem saving as txt file 1
Fixed Length, Text Formatted 2
import data from .txt to excel 6
importing txt file help needed 5

Top