tab delimited text not aligned properly in dos editor

  • Thread starter Thread starter jd
  • Start date Start date
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.
 
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.
 
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.
Click to expand...
 
Back
Top