Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
F2 is exactly what I needed - thanks so much! –  Evan Nov 1 '12 at 12:42
    
btw does this also work for excel? –  Evan Nov 1 '12 at 12:42
    
funny, I don't use LibreOffice - so yeah, my answer was based on excel ;) –  Jook Nov 1 '12 at 12:43
    
ah OK - works for both then :D –  Evan Nov 1 '12 at 12:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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