Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 5th 08, 04:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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?

  #2   Report Post  
Old September 5th 08, 05:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 793
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   Report Post  
Old September 5th 08, 11:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old September 5th 08, 11:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old September 5th 08, 11:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
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   Report Post  
Old January 12th 09, 03:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
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   Report Post  
Old January 12th 09, 06:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 02:09 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017