A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

excel adds quotation marks when pasting text



 
 
Thread Tools Display Modes
  #1  
Old September 5th 08, 04:26 PM posted to microsoft.public.excel.misc
Justin Larson[_2_]
external usenet poster
 
Posts: 26
Default excel adds quotation marks when pasting 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?
Ads
  #2  
Old September 5th 08, 05:03 PM posted to microsoft.public.excel.misc
Sheeloo
external usenet poster
 
Posts: 795
Default excel adds quotation marks when pasting 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  
Old September 5th 08, 11:17 PM posted to microsoft.public.excel.misc
Justin Larson[_2_]
external usenet poster
 
Posts: 26
Default excel adds quotation marks when pasting 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.

"Sheeloo" wrote:

> 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?

  #4  
Old September 5th 08, 11:18 PM posted to microsoft.public.excel.misc
Justin Larson[_2_]
external usenet poster
 
Posts: 26
Default excel adds quotation marks when pasting text

)

that would help

"Sheeloo" wrote:

> 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?

  #5  
Old September 5th 08, 11:24 PM posted to microsoft.public.excel.misc
Justin Larson[_2_]
external usenet poster
 
Posts: 26
Default excel adds quotation marks when pasting text

Find and replace does not work for two reasons.

The first is that this is a productivity tool, and I'd 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"">
"


"Sheeloo" wrote:

> 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?

  #6  
Old January 12th 09, 02:02 PM posted to microsoft.public.excel.misc
Andrew Bennett
external usenet poster
 
Posts: 1
Default line breaks in cells cause this problem

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.


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
  #7  
Old January 12th 09, 05:02 PM posted to microsoft.public.excel.misc
Fred Smith[_4_]
external usenet poster
 
Posts: 2,389
Default line breaks in cells cause this problem

What problem?

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.

Regards,
Fred.

"Andrew Bennett" wrote in message
.. .
>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.
>
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com/default.aspx?ref=ng


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Quotation Marks as Text Kelly C Excel Discussion (Misc queries) 2 August 3rd 08 06:20 PM
Generating text surrounded by quotation marks AaronQRules (a.k.a. Jeff) Excel Discussion (Misc queries) 5 July 30th 07 08:12 PM
After exporting how do I remove quotation marks from text cells Marty G Excel Discussion (Misc queries) 0 July 29th 05 02:54 AM
How do I concatenate text that actually contains quotation marks? Excel Distress Excel Worksheet Functions 3 April 15th 05 02:23 PM
Excel Quotation Marks! MaxFrance Excel Discussion (Misc queries) 6 March 29th 05 10:45 AM


All times are GMT +1. The time now is 01:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©2004-2014 ExcelBanter.
The comments are property of their posters.