Save As Tab Delimited File Adds Quotes

M

Mary Beth

Hi, I'm wondering if there is a solution to this
problem. When I save an Excel spreadsheet as a tab
delimited file it adds quotes to the page. I can't seem
to find any solution to this.

Any help is greatly appreciated.

Thanks, Mary Beth
 
D

Dave Peterson

If you don't like the way xl does it, I think you'll need a macro.

You could write your own export program or use Earl Kiosterud's text export
program.

It's available at:
It's available at Tushar Mehta's site:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Earl has a bunch of options that you can specify.

And you may want to look at Chip Pearson's code:
http://www.cpearson.com/excel/imptext.htm
 

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

Top