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?

Community
  • 1
user206602
  • 11

1 Answers1

2

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

chuff
  • 3,534