Excel从单元格复制到剪贴板 [英] Excel copy from cell to clipboard

问题描述

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

然后我将这个单元格复制到剪贴板使用ctrl + c并发送到记事本使用ctrl + v我得到这个

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

  

所以我所有的字符串被引用并修剪了第一个单引号，还添加了额外的引号到url，如何防止更改并获取字符串。

解决方案

Excel将第一个'标识为单元格中的值为文本的符号。

确保将将其粘贴到记事本中的两倍？

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.

解决方案

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?

这篇关于Excel从单元格复制到剪贴板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！