I'm trying to paste some data into a spreadsheet, but since the data contains \n
characters within it, the cells below are overwritten. I want to paste the entire bit of data into a single cell.
Eg:
some \n
multiline \n
data
Needs to go into a single cell, rather than cells in 3 rows.
I'm interested in knowing how to do this for both LibreOffice and Excel.
Cheers