I have an Excel (2013) spreadsheet that contains multiline text in some of the cells.
Word-wrap is enabled for those cells, so they appear with line breaks correctly. However, the cells in question are protected (and I don't have the password), so I can't click into the edit box to copy from there.
If I use Ctrl-C to copy to the clipboard, then paste into Notepad, then all the line breaks are removed and double quotes are placed around the text.
How can I copy out the text and keep the line breaks?
Notepad doesn't interpret line breaks as cleverly as more fully-featured text editors. Your best bet is probably to try copy/pasting into either Wordpad, or to download something like Notepad++ (https://notepad-plus-plus.org/download/) and paste into that first.
This answer does a nice job of further explaining the issue:
https://superuser.com/questions/362087/notepad-ignoring-linebreaks