Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,
    I'm using Excel 2003. I'm exporting data from another program, bringing it into Excel comes in fine. All data has quotes around it in the cells. It has to be this way because of how it imports into another system.

    Once into Excel I do a SaveAs to save it as a CSV file and once I do that it adds 2 extra quotes around each data. Example: "John Doe", once into CSV: """John Doe""". It has to be a CSV file to import into this other system.

    Any thoughts?
    Thanks,
    Deb

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Deb,

    When you open your .CSV file in Excel it should automatically strip the quote marks from around the text fields.
    I tested this with 2003 and it seems to work fine on my machine {see below}. I saved the file as an .XLS file then re-saved it as a .CSV file and that also worked fine. If your Excel 2003 is not doing this you may want to reinstall it to make sure everything is correctly loaded.
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,203
    Thanks
    49
    Thanked 989 Times in 919 Posts
    Excel also adds an additional " if you have one in your data.
    My"Data > "My""Data"

    cheers, Paul

Posting Permissions

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