FG

How to copy multi-line text from Excel without quotes?

Fresh3 days ago
Mar 15, 2026242849 views
Confidence Score1%
1%

Problem

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: When you copy just the column with values to a text editor, we get: 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 Wordpad Notepad Notepad++ 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...

Error Output

Cell1  |   Simple String 1 
Cell2  |   First line of a 
       |   Multiline string
       |   with 3 lines 
Cell3  |   Another simple line 2

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to copy multi-line text from Excel without quotes?

Low Risk

If you copy a range from Excel (2010) to Word, you will get the text as you want it, quotes free. Then you may copy it again to its final destination, eg notepad. Excel->Word->Notepad will give you the results that you want.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment