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 | |||
Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Creating CSV Comma Delimited File | Excel Discussion (Misc queries) | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |