How do I transfer data from Excel to txt file and maintain same number of spacing?

Hi, I have an Excel file with lots of data and I am trying to copy the data from this file into a txt file, but I must maintain the same amount of spacing between the columns. When I copy it into a txt file, my columns become all scrambled. Does anyone have a fix for this?How do I transfer data from Excel to txt file and maintain same number of spacing?
Hi,


CSV (Comma Seperated Values) is the best format for your requirement. it is universal and many applications including access and sql accept this. this takes less space on ur drive and keeps the formats (u r looking for) same.How do I transfer data from Excel to txt file and maintain same number of spacing?
Duplicate the excel file (give it a different name) - just use File %26gt; Save As and give it a new name.





Delete everything except for the data you need in a text file (remember this is a duplicate excel file, so you're not destroying your original).





Now go File %26gt; Save As again, but use the pulldown menu and select one of the Text options (like a TAB formatted text file). This should then maintain the column structure for you.
save it as a csv file....it will be fine....


Don't use tab....csv is so much more 'universal' and if you open it in notepad, you can see ....even though it isn't name whatever.txt, it is in fact a text file....