When you create a multi-line string in an excel cell (by using Alt-Enter), if you copy that cell to a text editor, excel will automatically add double quotes (") around the full string, ie:
Cell1 | Simple String 1 Cell2 | First line of a | Multiline string | with 3 lines Cell3 | Another simple line 2
When you copy just the column with values to a text editor, we get:
Simple String 1 "First line of a Multiline string with 3 lines" Another simple line 2
How can I tell excel not to add the quote around multi-line text when copying from excel?
Edit: Text Editors that I've tried that display this behaviour:
- MS Word
- SQL Server Studio
If you have a suggestion on using a particular editor (or one of the above) please tell me which one & how to use it...