Results 1 to 3 of 3

Excel adding quotation marks when saving text file

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Excel adding quotation marks when saving text file

    Hi,

    Excel is adding quotation marks to my my data when saving as a tab delimited text file.
    I know (after some googling) that you can overcome this by using the 'PRINT' command instead of 'WRITE', but I'm not doing any VB coding so it doesn't seem to apply in my case and I wouldn't know how to do it if it did.

    I'm simply manually selecting 'Save As' and creating the file that way.

    Does anyone have any suggestions please? Thx

    [EDIT]Solved Well....Kind of. What I've learned since making my post may help others, so I came back with a bit of an update.

    For some reason, it took a while to occur to me that I could just copy and paste my desired selection into a blank text file instead; I think I assumed ti would lose the formatting, but of course it doesn't.

    Anyway, I've done that now and it works fine. I can live with this for now, but since the whole point of my Excel tool is to help me automate my workflow, it kinda defeats the purpose.

    So I'm still keen to learn how I can stop Excel adding the quotation marks when exporting.

    During my search, I came across this: http://www.asap-utilities.com/index.php

    It's an action-packed Excel utility suite that integrates seamlessly with Excel and has 300 macros and other functions. It's free for personal use and a reasonable price for commercial use. Definitely worth checking out.

    I was eager to try this out to see if the files it exported contained the quotation marks and sadly, they do, so there's obviously still something I need to do with Excel to stand any chance of avoiding them.

    Any leads?

    p.s.
    Hope I didn't break any forum rules with the link I posted. I'm sure it's probably a well-known product in this forum, which may or may not have some history here, good or bad. I wouldn't know, since I'm new to all this, but I felt it was worth mentioning.
    Last edited by theaudiobookguy; 07-31-2009 at 11:44 PM. Reason: Partially Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1