| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save Excel string data without the leading/trailing DQ (")s
I want to save lots of sheets as *.txt files and I want the cell data that
are strings be saved without the usual leading or trailing double quotes (DQs) ("s). This is very important for using those saved files as input files to other popular codes. How can I turn-off these leading and trailing double quotes when saving strinig data from an Excel spreadsheet to an ASCII text file??? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to save Excel string data without the leading/trailing DQ (")s
http://www.mcgimpsey.com/excel/textfiles.html
-- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "Patrick Bailey" <Patrick wrote in message ... I want to save lots of sheets as *.txt files and I want the cell data that are strings be saved without the usual leading or trailing double quotes (DQs) ("s). This is very important for using those saved files as input files to other popular codes. How can I turn-off these leading and trailing double quotes when saving strinig data from an Excel spreadsheet to an ASCII text file??? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Excel - highlight new data (by date ?) and avoid 'Save As' | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
