![]() |
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! |
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