Multi line text from Excel to Notepad

Here’s something that i noticed today when working with Excel and notepad .

When a multi line text is created in a cell in Excel and then copied to a different text editor , you will find that the double quotes is added around the string .

For example , assume the below multi line text in a excel sheet cell .

Multi line text from Excel to Notepad - 1

Multi line text from Excel to Notepad - 1

Copying it to a notepad will lead to the following

Multi line text from Excel to Notepad - 2

Multi line text from Excel to Notepad - 2

 

Share