+ Reply to Thread
Results 1 to 3 of 3

Excel is adding extra double quotes when I save to txt and csv

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    2

    Angry Excel is adding extra double quotes when I save to txt and csv

    Hi,

    I have an annoying problem! I get several extra double quotes when there is a double quote in my text.

    Here is an example:

    The original text:
    INTEGRATED MODULAR TOOL 36" PIPE BASIC

    After I have saved the file to txt or csv I get this text:
    "INTEGRATED MODULAR TOOL 36"" PIPE BASIC S"

    I can't see the extra double quotes in Excel but I get problems when I use the file in the next step. I can see them it I open the file in a text editor.

    Is there any setting or way to avoide this??

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Excel is adding extra double quotes when I save to txt and csv

    Hi,

    I found this article on just that subject:
    http://www.pctechblog.com/software/e...-double-quotes

    the script on the site only worked after I introduced the variables a, b and c, I don't know enough about VBA to troubleshoot that, but the script below worked beautifully on a scenario like yours.


    Please Login or Register  to view this content.
    cheers

  3. #3
    Registered User
    Join Date
    07-28-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel is adding extra double quotes when I save to txt and csv

    I will try this tomorrow when my friend is here. I don't know that much about VB coding or at least I don't remember much about it.

    I will get back with the result.

    //Kristoffer

+ Reply to Thread

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