Forum Discussion

Edgar Soares's avatar
Edgar Soares
Copper Contributor
Feb 28, 2018

Extra and "double" double quotes when using carriage return in formulas

Hi, all. I am attempting to copy Excel cell contents in a text file (for further use later). However, when copying and pasting cells with formulas that contain both quotes ("") and carriage retur...
Excel Desktop
Formulas & Functions
LimehouseJohn's avatar
LimehouseJohn
Copper Contributor
Jun 12, 2025
Edgar Soares wrote:

the result contains "extra" quotes at odd places.

This all used to work perfectly at one time then MS (with their usual wisdom - NOT!!!) screwed it all up but here is my workaround.  You need to take the text via an intermediate stage of copying and pasting it into MS Word.

So, first copy your cells containing the quotes (standard ctrl+C) in Excel.  Paste the result into an empty MS Word document, making sure to "Keep the source formatting".  This results in a standard MS Word table (but without the extra double quote marks in the cells).  Next, select the whole table and then from the "Table Layout" menu which appears in the ribbon, select "Convert to text".  This results in the text within the MS Word table (and still without the extra quotes) appearing as just plain text in the document.  So, just select the whole text, then copy and paste it to wherever it is required (in my case it is some JavaScript lines computed in Excel for inclusion in an HTML file).  What a shambles MS are for making everyone jump through these hoops.

Best regards

John

Resources