Excel copy from cell to clipboard

Question

In Excel 2013 into cell i post this string

'<xml xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">'

Then i copying this cell to clipboard using ctrl+c and post to notepad using ctrl+v I get this

"<xml xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">'
"

So all my string became quoted and trimed first single quote, also added additional quotes to url, how to prevent changes and get string as it is.

enter image description here

Copy/paste or keyed or get from VBA does no matter, result the same — Dmitrij Holkin, Jan 07 '15 at 14:09
Yes but it is no change anything i tryed trim newline and the same — Dmitrij Holkin, Jan 07 '15 at 14:28
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/68347/discussion-between-dmitrij-holkin-and-pnuts). — Dmitrij Holkin, Jan 07 '15 at 14:35

score 0 · Accepted Answer · answered Jan 07 '15 at 14:02

0

Excel identifies the first ' as Symbol that the value in a cell is text.

And are you sure it is doubling the " when pasting it into notepad?

answered Jan 07 '15 at 14:02

AngularDev

Yes I'm shure! you can test by yourself – Dmitrij Holkin Jan 07 '15 at 14:03
yaa i have tested it and it didn't actually doubled the `"` only problem was that first single quote was missing which is natural in case of Excel – AngularDev Jan 07 '15 at 14:05
YOU MUST BE DOING IT IN vba I GUESS – AngularDev Jan 07 '15 at 14:06
I do this in VBA also and result is the same – Dmitrij Holkin Jan 07 '15 at 14:07
DO `cell.PrefixCharacter & cell.Value` to get the proper string in VBA – AngularDev Jan 07 '15 at 14:14

1 Answers1