View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default How do I save excel file in text format without columns?

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

On Jul 15, 12:31*pm, Tuuti wrote:
I want to save my excel file in text format (Tab delimited *.txt) without
columns so that the lines would be separated by ¤. *How ?++