I think you can use this macro from Chip Pearson:

http://www.cpearson.com/excel/imptext.htm#Export


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy (now in Berlin)
dza7 wrote:
Hello,

I'm attempting to creating a tabbed delimited file from excel that is
going to be used for entering sale orders in an Oracle based
platform. The problem I'm running into right now is that I have
several blank cells in my excel spreadsheet that need to be shown as
"" in the text file when I "save as" to a txt file.

I've tried different methods and none of them have worked:
* I've tried changing all the blank cells to "". When "saved as" a
txt file those cells become """".
* I've tried changing the blank cells to a period, an apostrophe, a
space and none of those methods have worked either.

In the end I can edit this txt file in wordpad and replace the
incorrect characters but I'm hoping there is something I can change in
my excel template to help wit this process.

Thanks,

Dza