How do I save excel file in text format without columns?

  • Thread starter Thread starter Tuuti
  • Start date Start date
T

Tuuti

I want to save my excel file in text format (Tab delimited *.txt) without
columns so that the lines would be separated by ¤. How ?
 
Try going to file -> save as and select tab delimited from the drop
down box.

If you then open the file in notepad (or any text editor) you'll see
the tabs between each column
 
You must log in or register to reply here.

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

Similar Threads

Converting Numbers from Excel to TXT files 2
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Keeping Column Formatting When Converting to TXT 1
Drag text file to Excel -- stopped working 5
Columns formatted As Dates Are Exported as a Number to Text 1
How do I prevent a long string of text from wrapping in a text fil 1
Importing text with text qualifier 2
opening extensionless text files 2

Back
Top