How to copy multi-line text (hard Return) from Excel without extra quotes?
I see a lot questions on this . . . Can Notepad++ do whatever Word does, to remove quotes, or is there a plugin? Then I can just copy from Excel, and paste into Notepad++
These are the best answers I’ve seen
#1. How to copy multi-line text from Excel without quotes? . . . http://superuser.com/questions/324271/how-to-copy-multi-line-text-from-excel-without-quotes
If you copy a range from Excel (2010) to Word, you will get the text as you want it, quotes free. Then you may copy it again to its final destination, eg notepad . . .
It’s not Excel’s problem. Like the previous poster says, it’s just outputting valid CSV data. It’s going to be up to the editor your putting it into to look after formatting it. I would suggest using something a little smarter than notepad… You could use MS Word as a go-between from Excel to whatever text editor you wanted to use besides word.
#2. create your own macro that creates the output text file . . .
Getting Rid of Extra Quote Marks in Exported Text Files . . . http://excel.tips.net/T002237_Getting_Rid_of_Extra_Quote_Marks_in_Exported_Text_Files.html
#3. Excel - leave out quotes when copying from cell . . . http://stackoverflow.com/questions/24910288/excel-leave-out-quotes-when-copying-from-cell/24913557#
. . . Have you tried changing the format to something other than number? I think I have seen ways around that . . . Number, General, Text (doesn’t even Concatenate then) - no luck
. . . To copy the cell value as pure text, to achieve what you describe you have to use a macro:
#4. This gets the quotes: . . . Use the Clean() function in Excel . . . However, it also removes the line feed characters
Something I’ve found out:
In Word 2010, if you Right-click / “Paste Special,” the Paste Options give you the following:
Keep Source Formatting (K) . . . no quotes, good
Merge Formatting (M) . . . no quotes, good
Link & Keep Source Formatting (F) . . . no quotes, good
Link & Merge Formatting (L) . . . no quotes, good
Picture (U) . . . a few text characters in a box - I’m not pasting a picture
Keep Text Only (T) . . . quotes, like what I see in NP++ and Notepad
Any program which can’t handle formatting marks, or non-printing characters, will give you the quotes.
The default paste in Word “understands” the line breaks from Excel, and retains them - Notepad++ retains them, also
Notepad doesn’t understand the line breaks, though, so either ignores them entirely, or will indicate to the user that there is a “not-understood” character in the pasted string, by putting quote marks around it.
What’s happening in Notepad is by design, and there’s probably nothing you can do to fix it - but what about in Notepad++ ?
I see that MS WordPad does not add the quotes, either
Sometimes the export filters used by Excel can produce undesired results in the exported file.
For instance, when you export to a tab-delimited text file, some Excel filters place quote marks around the text in a cell.
[ Is Notepad++ tab delimited . . . Could this be similar to what happens when you copy and paste? ]
Maybe the TextFX plugin has something . . . http://sourceforge.net/projects/npp-plugins/files/TextFX/
Edit / Paste Special / Paste HTML Content . . . too many extra characters
Edit / Paste Special / Paste RTF Content . . . too many extra characters
Edit / Paste Special / Paste Binary Content . . . no extra characters, but it has the quotes / double quotes
NP++ is not doing something to
CR = carriage return
LF = line fed
MS Word and MS WordPad are doing
Is it that NP++ does not understand what is CR and LF ? Seems like it.
But, if I type the following (below) into MS Word, and then copy and paste it into NP++, I get the exact same thing, with no double quotes . . . and there is a CR LF after each letter . . . so, it seems like CR LF is not the issue, it’s something else . . . Does something else copy from the Excel cell that is hidden? I took a look at what was in there with an Excel Add-In called “Cell View,” but all I saw were the letters.