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

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 ?
 
T

Tim879

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
 

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

Importing text with text qualifier 2
Converting Numbers from Excel to TXT files 2
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
opening extensionless text files 2
Drag text file to Excel -- stopped working 5
Open csv file with Leading Zeros 1
How to use Windows command within Excel macros 2
in 2003 i have 0 text file conrt to 2007 number 1

Top