If I copy text with a line break in it, like this:
1st line
2nd line
and then paste in into a Google Sheets cell, then it pastes '2nd line' into the cell below.
What are the ways to avoid this?
Google Sheets – Pasting Text with Line Breaks Populates Multiple Cells
google sheets
Related Topic
- Google-sheets – How to add line breaks in a cell before specific keywords in Google Sheets
- Google Sheets – Using IMPORTXML with Line Breaks
- Google-sheets – Rich text formatting in a Google Sheets cell
- Google-sheets – Macro to copy and paste values from multiple cells as text into a Note
- Google-sheets – way on google sheets to paste text and automaticly create new rows with every line break or etc
- Google-sheets – “Export to Excel Default” when pasting cells into Google sheet from Excel
Best Answer
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...