4

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

1 Answer 1

7

Well for a single insert, I would just use F2 on the cell or enter it any other way, so you get the edit mode, then paste it.

Another way would be to use the formula-input at the top of the worksheets. Select your destiny cell, then select the formula-input, then paste.

Is is more complicated, when you have multiple multirow cells to insert.

4
  • btw does this also work for excel?
    – Eva
    Nov 1, 2012 at 12:42
  • funny, I don't use LibreOffice - so yeah, my answer was based on excel ;)
    – Jook
    Nov 1, 2012 at 12:43
  • ah OK - works for both then :D
    – Eva
    Nov 1, 2012 at 12:43
  • One caveat for this approach is that, if your source text contains any formatting, such as bold, variations in font size, etc., those will not be retained. Still, it's the best solution available. Jan 19, 2017 at 15:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.