1

I have tried this in Notepad and Notepad++, but can't get it to work. What I want to do is close to the opposite of this post: How to copy multi-line text from Excel without quotes? I want to paste into a spreadsheet and keep the text in a single cell. The headache is the CRLF; there seems to be no find/replace options to create the Excel equivalent of Alt+Enter. The original text is coming from emails and so probably carries HTML formatting, but I would be happy to use a text editor as an intermediate step for the reformat find/replace. Did anyone deal with this problem before?

Improve this question
1
  • 1
    Don't paste directly into the cell. Click the cell you want to paste into, then paste into the entry bar at the top of the sheet. The CRs will be retained.
    – Paul
    Mar 13, 2013 at 0:56

1 Answer 1

Reset to default
2

Paste the text into the formula bar, instead of into the cell.

Improve this answer
2
  • 2
    Thanks Paul, never would have found that trick. Further, after you have done it once (and first for that column) it seems that in excel2010 it remembers and next time you can just paste straight into the cell (no need to select cell and then paste into formula bar). Great trick.
    – user206602
    Mar 13, 2013 at 1:37
  • umm, it seems it might be a bit random for it to keep working after you have done it once. Also note this paste into the formula bar works in the google spreadsheet.
    – user206602
    Mar 13, 2013 at 4:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .