Google-sheets – How to copy from Google Spreadsheet without it editing the source data

google sheets

Every time I copy and paste from a Google Spreadsheet, it adds a double quote before and after everything, and duplicates every single double quote.

For example, if I copy:

This is a "string" of sorts.

And paste ANYWHERE else (I can reproduce it on Windows, Mac, Linux, Notepad++, SublimeText, Xcode…) it results into:

"This is a ""string"" of sorts."

How can I copy and paste so that A" results in A" instead of "A""?

EDIT: I am talking about when you copy an entire cell, if you enter edit mode in a cell and copy the contents, the copy works fine. But you cannot copy formula-based cells this way, or multiple cells.

Best Answer

I found a workaround for this:

Just replace all "\n" symbols (LF - Line feed or 0x0A in ASCII) that's represented by CHAR(10) in Formulas by "\r" symbols (CR - Carriage return or 0x0D in ASCII) that's represented by CHAR(13).

And when you copy and paste as plain text it will be without added quotes in it.

Here is formula to do it:

=SUBSTITUTE(A1,CHAR(10),CHAR(13))
Related Topic