I have a cell with a multiline value. For example:
Testing line 1
Testing line 2
When I copy it and paste it at any text editor, there are quotation mark at the front and at the end of the value. That is
"Testing line 1
Testing line 2"
How can I get rid of it?
This is an expected behavior. The quotation marks are necessary to distinguish the groupings of the data with respect to each cell. In the example below, "TEST and TEST2" are separated from that of "TEST3 and TEST4" (with the use of quotation marks) since both pairs belong to different cells.
To remove the quotation marks, i recommend the following workarounds: