when saved as text

B

Brandon

When my excel file is saved as a .txt the widths of the
cells are not created by spaces. There will be 5
characters with 6 character spots left in a cell (so the
width is 11) and when saved as .txt there will be only 1
or 2 spaces inbetween that cell and the next. If there is
any way to fill it without putting spaces please let me
know. Or if there is a way to make the area inbetween the
two cells larger when outputted as a .txt. Thank you
 
E

Earl Kiosterud

Brandon,

I'm not sure what you want. If your sheet contains

A B C D
1 23 456 7,890

A txt file will give:
1,23,456,"7,890"

A tab-delimited file will give
1 --> 23 --> 456 --> 7,890
where --> represents a tab character (ascii code value 9)

A prn file will give
1 23 456 7,890

In the prn file, the amount of spaces will vary with the width of the
columns. For this to be consistent, use a non-proportional font, like
Courier in the worksheet. Set the column widths as necessary for the amount
of spaces.
 
Top