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
Copying data into new text file with script 0
Autonumber field in Excel that behaves the same as Access 0
MS Project Import Error Row 1 Column 5 2
Cumulative formula for word table 0
import data from txt file to an existing excel file 1
Extract data in rows (with line breaks) to form a table 0
Importing multiple text files and getting certain figures. 3

Top