I'm creating a multi-line string in an Excel cell by using "Alt-Enter". If you copy that cell to an text editor, Excel automatically adds double quotes around the full string.
Cell1 | Simple String 1
Cell2 | First line of a
| Multiline string
| with 3 lines
Cell3 | Another simple line 2
However, when you a column with editors, it appears this way:
"First line of a Multiline string with 3 lines"
Another simple line 2
Is there a way I can tell Excel to add the quote around the multi-line text?
September 10, 2013 6:59 PM
September 10, 2013 7:43 PM