Results 1 to 5 of 5

Thread: Excel add a quotation mark everytime when I paste some text

  1. #1
    Join Date
    Jan 2011
    Posts
    15

    Excel add a quotation mark everytime when I paste some text

    I have a spreadsheet that I export a portion of to .kml. The very first line is the xml declaration, but when I copy my range from excel into a text editor, it adds in quotation marks where I don't want any. I can't do something simple, like find and replace, because there are quotation marks that I want to retain, but excel adds in a bunch that make the file unusable.
    For example, the first cell in my range contains this, just text, no formula:

    <?xml version="1.0" encoding="UTF-8"?><kml
    xmlns="http://earth.google.com/kml/2.2"
    xmlns:atom="http://www.w3.org/2005/Atom">


    When I copy that into any other program it comes out like this:

    "<?xml version=""1.0"" encoding=""UTF-8""?><kml
    xmlns=""http://earth.google.com/kml/2.2""
    xmlns:atom=""http://www.w3.org/2005/Atom"">
    "

    Note all the extra quotation marks. Is there any way to get around this infurating characteristic.

  2. #2
    Join Date
    Jun 2011
    Posts
    798

    Re: Excel add a quotation mark everytime when I paste some text

    I tested this on Excel 2003 and could not replicate the problem. Assuming first and last quotes are put in by you, try searching for "" and replacing with ". Which version of Excel are you using.

  3. #3
    Join Date
    Jun 2011
    Posts
    487

    Re: Excel add a quotation mark everytime when I paste some text

    I am also using Excel 2003. Shoot me an email and I can forward the sheet I am using if you want. I will try to replace "" with ", I'll have to see if there are any other adverse effects, because it doesn't seem to double them up when the quotes are a result of a formula pulling from another cell. I tried to make my problem cell a formula, but that didn't work.

  4. #4
    Join Date
    Jun 2011
    Posts
    635

    Re: Excel add a quotation mark everytime when I paste some text

    Find and replace does not work for two reasons. The first is that this is a productivity tool, and I would prefer not to have to use a workaround every time I use it. But aside from that, the program adds quotes in places where there were none before, so they are not always doubled up. I can't just get rid of them all, because the text does contain quotes that are necessary for the xml code to work. the cell in question (the one I've identified, but there may be more, I am compiling the contents of about 500 cells with each "export") contains this text:

    <?xml version="1.0" encoding="UTF-8"?><kml
    xmlns="http://earth.google.com/kml/2.2"
    xmlns:atom="http://www.w3.org/2005/Atom">


    This is what shows up when I copied the cell and pasted it right into this reply window:

    "<?xml version=""1.0"" encoding=""UTF-8""?><kml
    xmlns=""http://earth.google.com/kml/2.2""
    xmlns:atom=""http://www.w3.org/2005/Atom"">

  5. #5
    Join Date
    Jul 2011
    Posts
    640

    Re: Excel add a quotation mark everytime when I paste some text

    I was having this problem, have just found that it puts the extra quotes in because I had put line breaks (alt-enter) in the cells to make the xml neater. Take the line breaks out and it will be fine. If you are replying to a previous post, you need to keep it in the same thread rather than creating a new thread. Also, virtually everyone includes the original post in their reply, as it helps follow the conversation.

Similar Threads

  1. Replies: 5
    Last Post: 26-04-2012, 04:16 AM
  2. Can only paste text in Excel 2010
    By Logikar in forum Windows Software
    Replies: 6
    Last Post: 13-04-2012, 03:59 PM
  3. Replies: 2
    Last Post: 02-02-2012, 01:16 PM
  4. What does double quotation in Microsoft Excel means
    By TheMirza in forum MS Office Support
    Replies: 2
    Last Post: 27-01-2012, 08:03 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

Tags for this Thread

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
  •  
Page generated in 1,713,893,568.30920 seconds with 17 queries