Menu
Problem:
When copying a cell from Excel outside of the program, double-quotes are added automatically.
Details:
I'm using Excel 2007 on a Windows 7 machine. If I have a cell with the following formula:
="1"&CHAR(9)&"SOME NOTES FOR LINE 1."&CHAR(9)&"2"&CHAR(9)&"SOME NOTES FOR LINE 2." The output in the cell (formatted as number) looks like this in Excel:
1SOME NOTES FOR LINE 1.2SOME NOTES FOR LINE 2. Well and good. But, if I copy the cell into another program, such as notepad, I get annoying double-quotes at the beginning and end. Notice the tabs created by "CHAR(9)" are kept, which is good.
"1 SOME NOTES FOR LINE 1. 2 SOME NOTES FOR LINE 2." How can I keep these double-quotes from showing up, when I copy to another program? In other words, can I keep these from being automatically added when the cell is copied to clipboard?
528
Backup Solution First copy paste content from Excel into Word document (use Ctrl+V for pasting or use Merge Formatting in Paste Options). Then you can copy paste the same from the word document into the other program (notepad++). It will appear without the quotes.
Microsoft Excel uses double quotation marks to signify text within formulas. When it sees these marks, it uses the text and discards the quotes. Typing quotation marks directly into a cell is not an issue because Excel automatically recognizes that you are entering text and therefore keeps the quotation marks.
I just had this problem and wrapping each cell with the CLEAN function fixed it for me. That should be relatively easy to do by doing =CLEAN(, selecting your cell, and then autofilling the rest of the column. After I did this, pastes into Notepad or any other program no longer had duplicate quotes.
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
