Saving to a text file

[Fan924]

1260 6 2
1266 26 12
1280 10 4
128A
128A 172 12 12
1336
1336 34 16
1358 8 3
I have 4 columns of data that looks like this when saved to a text
file. All compresed.

1260 6 2
1266 26 12
1280 10 4
128A
128A 172 12 12
1336
1336 34 16
1358 8 3
I would like it formated more like this when saves to a file. Excel
97. Thanks in advance.

 

[Guest]

Not sure if xl97 has a tab delimited option for txt files but look through
the file type save as options and if it does then that should do the trick.

Regards,

OssieMaxc

 

[Fan924]

After reading your post, I found this
& vbTab

I merged the info into one cell and used a write to file macro that
exports columns
..
Cells(StartIt, 12) = " " & Address & vbTab & FTotal & vbTab & FSizeX

Now it looks like this. Thanks.
1260 6 2
1266 26 12
1280 10 4
128A 172 12x12
1336 34 16
1358 8 3
1360 22 10
1376 8 3
137E 8 3
1386 6 2
138C 6 2
1392 107 12x7
13FD 8 3
1405 10 4

 

[Fan924]

With Courier Font, it lines up perfect.