tab delimited text not aligned properly in dos editor

J

jd

I have opened a comma delimited .txt file into excel
I need to save it as a tab delimited text file
when I open it in dos editor, the data is not aligned properly. I have some
of columnA data in ColumnB etc. Is there a maximum width? My longest data
is
12 digits long. I've even padded emty cells with bogus data thinking that
was the problem but it's still not lining up properly.
thanks in advance.
 
E

Earl Kiosterud

JD,

I don't think there's any guarantee that tab-delimited data will line up in
an editor, unless it has tab stops that are known to be far enough apart for
the largest field you have. Try Word or WordPad. They have tab stops.
 
D

Dave Peterson

See one more reply to your other thread.
I have opened a comma delimited .txt file into excel
I need to save it as a tab delimited text file
when I open it in dos editor, the data is not aligned properly. I have some
of columnA data in ColumnB etc. Is there a maximum width? My longest data
is
12 digits long. I've even padded emty cells with bogus data thinking that
was the problem but it's still not lining up properly.
thanks in advance.
 

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

Top