ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to save Excel string data without the leading/trailing DQ (")s (https://www.excelbanter.com/excel-discussion-misc-queries/71988-how-save-excel-string-data-without-leading-trailing-dq-s.html)

Patrick Bailey

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!


Peo Sjoblom

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!




All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com