It can be done.........many know how and very few have a problem.

In which application are you opening the *.csv file?

NotePad or some other text editor?

What is the cell formatting of your original data in the worksheet?


Gord Dibben MS Excel MVP


On Wed, 28 Jan 2009 15:40:14 -0800, naomi
wrote:

Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the
contents of each cell. I need a single space. Apparently it can be done,
but no-one sems to know how.


"David Biddulph" wrote:

Other text options are space delimited (.prn) or comma separated (.csv).
--
David Biddulph

"naomi" wrote in message
...
Hi,
I need to convert an excel file to a text file which is not tab delimited.
Does anyone know how to do this? If I "save as" a text file, whatever
option
I choose, there are tabs between the cells.