If I copy text with a line break in it, like this...
1st line
2nd line
...and then paste in into a Google Docs spreadsheet cell, then it pastes '2nd line' into the cell below. What are the easiest ways to avoid this?
Tell me more
×
Web Applications Stack Exchange is a question and answer site for
power users of web applications. It's 100% free, no registration required.
|
|
|
Based on http://productforums.google.com/forum/#!category-topic/docs/formatting/-uEh3jguVu0 you can " copy the info single cell by single cell and paste the information in edit mode of the receiving cell; i,e. double-click the cell first before you paste the single cell contents". Though this is hardly 'easy' so there may be a better answer out there... |
|||
|
|
|
This drove me crazy until I accidentally got my list to paste properly. You have to double or triple click in the target cell so that the cursor appears. Then you can paste a list with line breaks into a cell in a Google spreadsheet. I realize this was asked a year ago but my first search brought me to this post so I thought I'd share. |
|||||
|
