How to save Excel string data without the leading/trailing DQ (")s

G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to suppress double quotes on save as tab delimited 1
how to save Excel data as ASCII* text? 1
Excel 2003, how do I save without having to say overwrite? 1
How write Macro to save worksheet to a RELATIVE address 9
how do I block users to save the excel file if conditions not met 1
Excel Macro Save CSV Cell without Prompting 1
How can I make Excel save Unicode CSV data correctly? 0
Missing commas in csv save 2

Top