Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Creating Tabbed Delimited Text File - Need help with blankcell output | Excel Discussion (Misc queries) | |||
Converting Tab Delimited Text File to A Comma Delimited Text File | Excel Programming | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |